wildpianist
10-30-2007, 03:02 AM
Hello
I'm having another problem.
I've got a userform and what I want to do is when the value of the box equals nothing then a box to pop up saying "Please enter something!" or words to that effect.
However I can do
if txtBox1.Value="" then MsgBox "Please enter something"
then when I click OK for the box to disappear and not to log anything on my spreadsheet, I've tried Call UserForm_Initialize but it still comes up with the Thankyou box and thanking me for logging something (and logs something) albeit blank
Please help :help
I tried a Do Loop but ended up Looping "Please enter something" and then I had to Ctrl-Alt-Del excel
Hope this makes sense
Oh dear :(
I'm having another problem.
I've got a userform and what I want to do is when the value of the box equals nothing then a box to pop up saying "Please enter something!" or words to that effect.
However I can do
if txtBox1.Value="" then MsgBox "Please enter something"
then when I click OK for the box to disappear and not to log anything on my spreadsheet, I've tried Call UserForm_Initialize but it still comes up with the Thankyou box and thanking me for logging something (and logs something) albeit blank
Please help :help
I tried a Do Loop but ended up Looping "Please enter something" and then I had to Ctrl-Alt-Del excel
Hope this makes sense
Oh dear :(