here's the code
If LCase(sev.value = "1" or sev.value = "2" or sev.value = "3") _
AND NOT LCase(onformopen.sev = "1" OR onformopen.sev = "2" OR onformopen.sev = "3") then
Enotify.value=""
End If
End Sub
I still get an error on this Y
Printable View
here's the code
If LCase(sev.value = "1" or sev.value = "2" or sev.value = "3") _
AND NOT LCase(onformopen.sev = "1" OR onformopen.sev = "2" OR onformopen.sev = "3") then
Enotify.value=""
End If
End Sub
I still get an error on this Y
There are a couple things that I see. First, you would not use LCase for a numeric. If you need to check for numbers, use the isnumeric function like:
Secondly, I am assuming that you are using TextBoxes. ToCode:
If isnumeric(myvalue)=true then
msgbox "it is a number"
Else
msgbox "not a number"
end if
get the text inside the textbox box, you don't use
Instead you can use either one of the followingCode:
text1.value=mytext
Hope this helps.Code:
text1.text=mytext
'or
'The reason why this works is that .text is its default
'property.
text1=mytext
Lcase is used with strings, not boolean variables, but i don't know what you mean with Y
thanks for your help, but I don't want to use a message box. It so whent he user comes in and checks either 1,2,3 then in the email field in will pick up DEV. If the user comes back into the form and the severity is already 1,2,3 then email will be = ""
I guess you could just remove Lcase but leave the ()