Thread: textbox value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Woodi2 Woodi2 is offline
external usenet poster
 
Posts: 61
Default textbox value

I have a textbox (see below) that is checked to ensure a value no greater
than 365 has been entered. It works fine between 1 and 36 and 100 and 365.
Any value between 37 and 99 and it returns my error message. Any ideas why?

If Me.TextBox2.Value "365" Then
MsgBox "Max Inspection Frequency is 365 Days. Please enter 365 or less"
Me.TextBox2.SetFocus
Exit Sub
End If