textbox value - ExcelBanter

Posted to microsoft.public.excel.programming

Woodi2

external usenet poster

Posts: 61

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys	Minitman[_4_]	Excel Programming	0	February 22nd 05 08:50 PM
Textbox Bug? Missing/delayed update of textbox filled via VBA	MarcM	Excel Programming	0	November 4th 04 05:47 PM
Textbox Bug? Missing/delayed update of textbox filled via VBA	MarcM	Excel Programming	0	November 4th 04 05:43 PM
How to move cursor from one textbox control to another textbox con	Tom Ogilvy	Excel Programming	1	September 16th 04 03:42 PM
How to move cursor from one textbox control to another textbox con	KMoore007	Excel Programming	0	September 16th 04 02:47 PM

All times are GMT +1. The time now is 04:13 PM.

Menu

About Us