I have a userform that has 2 textboxes.
The problem that as soon as i type in 1 number the msgbox pops up. I need the message box to appear one the cell has been completed and then be checked.
Please Login or Register to view this content.
What am i doing wrong?
You have not said how the macro is run or triggered.
If you are using a TextBox1_Change macro you could test the length of the text before testing
You could also try using a TextBox1_AfterUpdate macroPlease Login or Register to view this content.
Another suggestion instead of using
TryPlease Login or Register to view this content.
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
You could use the TextBox_Exit event. The code will check the contents as another control takes Focus
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks