Blank value in Listbox

[vijay2482]

thanks to all who had helped me in the previous threads.......

Please Login or Register  to view this content.

this code will prompt a msg saying that the user has to enter a value in the textbox
it then adds the entered text in the listbox.

the change i want:
when the add button is clicked without any value in the textbox,a msg is prompted and the blank value is also entered in teh listbox......
how to change the code to avoid the addition of the blank value in the listbox???

thanks in advance

[Andy Pope]

You need to use IF THEN ELSE code.

Please Login or Register  to view this content.

If you disable the button at design time and add this code to the change event of the textbox you can stop the user from clicking the button until the textbox has text.

On a userform with a textbox and commandbutton.

Please Login or Register  to view this content.

[vijay2482]

thanks a lot....
that works perfect