vba Code: How to STOP the user on a specific TextBox to post a value

[Bib195]

Hello Everybody.
I have a running UserForm where I want to Force the User to post a value to a Specific TextBox and can't continue even pressing Enter or Space, etc... Also, which event to use to evaluate the User entry, as I tried [AfterUpdate} & {Change} and both didn't evaluate the entry specially when the user press Enter on the TextBox.
Any value must be entered into the TeaxtBox to continue. I appreciate your Help

 

[RobP]

Typically (as it seems you have some experience already with VBA), I would suggest at the time they press <ENTER>, your code will then evaluate the specific TextBox to see if they entered the value or not. If they did not, then you repeat, and throw up the UserForm again.

Usually users get the message (but you can add another text box with the reasoning also for intuitive user experience).

Cheers
Rob

 

[Bib195]

Typically (as it seems you have some experience already with VBA), I would suggest at the time they press <ENTER>, your code will then evaluate the specific TextBox to see if they entered the value or not. If they did not, then you repeat, and throw up the UserForm again.

Usually users get the message (but you can add another text box with the reasoning also for intuitive user experience).

Cheers
Rob

Thanks Rob for your quick response,
Actually I'm not experience with vba at all, just writing very basic commands.
Referring back to your reply, I have 2 questions:
1- in which event do I check for the "Enter" key pressed, i.e. AfterUpdate( ), Change( ), etc... knowing that Pressing "Enter" on the TBox doesn't trigger these events.
2- how exactly to check for "Enter" Key.
Regarding messaging the User, I have created a specific User-Messaging form that looks more sexy than Excel MsgBox function. So, I have my own way to communicate with the Users.
I guess now you will realize that I don't have any VBA experience at all. . I do appreciate your help.
Ehab.

 

[RobP]

Hi Ehab,

Its great you have managed to create such a sexy form, with your macros attached. In case it can be useful for you, here's a link to some basic UserForm interactions, by way of an example. It might help you understand where you need to play within your own code.

Userform in Excel VBA

This chapter teaches you how to create an Excel VBA Userform.

www.excel-easy.com

Hope it helps

Rob

 

[Bib195]

Hi Ehab,

Its great you have managed to create such a sexy form, with your macros attached. In case it can be useful for you, here's a link to some basic UserForm interactions, by way of an example. It might help you understand where you need to play within your own code.

Userform in Excel VBA

This chapter teaches you how to create an Excel VBA Userform.

www.excel-easy.com

Hope it helps

Rob

Thank you Rob, but I'm already Subscribes to this Page and unfortunately it doesn't have an answer to my question above!