Hello, i have a userform with combobox and textboxes and commandbuttons.
I just want to disable the textboxes if user didn't pick a month.
Example: If user try to enter a data in a textboxes without picking a month first, a message will prompt "Please Select a month".
I have a code for this, but when i select the commandbutton or exit the userform without selecting a date, it still prompting the message. I want this for textboxes only.
Please Login or Register to view this content.
Might not be the solution you want, but what I do to force an entry is to make the other boxes non-visable, nice and simple.
Hi puuts
Eliminate this CodeAdd this Code for each TextBoxPlease Login or Register to view this content.Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Similar idea, I would use the _Change event of the prior form controls to enable/disable the coming controls. This way they are all visible, but greyed out until appropriate
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks