in my userform i have three textboxes(1,2,3) and a button
i want the user must enter something in it
if u leave blank it should display an msg that u must enter an message in it
Please Login or Register to view this content.
in my userform i have three textboxes(1,2,3) and a button
i want the user must enter something in it
if u leave blank it should display an msg that u must enter an message in it
Please Login or Register to view this content.
Without sounding odd, did you even google how to check a textboxes contents, or validating textboxes in VBA?Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
i have used this but still having same problem
it just login please let me know where i was doing the wrong
Please Login or Register to view this content.
Last edited by baig123; 09-02-2014 at 07:51 AM. Reason: paragraph
It appears you have put the if statement in a place where it says IF blank THEN do these things. You should test each box for a blank before you move on. Something like an "event on exit"ing the textbox
Hopefully this sheds some light on it.Please Login or Register to view this content.
i have three textboxes
i tried but have put this code in each an textbox in my userform but still having the same
whenever i submit it should display that u should enter the textboxes after that it need to submit
i have attached my sheet
Last edited by baig123; 09-03-2014 at 01:35 AM. Reason: paragraph
Why don't you just disable your Submit-button and enable it after each of those three fields have values? It would be much nicer to see your code if it wasn't password protected.
Thanks for sharing ur knowledge
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks