excel vba - enter to run a marco

[brian032]

Hi, am fairly new with excel vba and forms. here's my concern:

I have a form (planning to create a DOS based like emulator) where i am using a textbox and planning to use the enter key from the keyboard to hide the said textbox and label then show a new textbox that i can use to type in and run another macro. How can i possibly do that?

 

[dhookom]

Welcome to Tek-Tips.

Let me see if I understand.
[ul]
[li]You have some macros (VBA subs) in Excel[/li]
[li]You have created a vba form with more than one text box[/li]
[li]When a user simply presses the enter key in one text box, you want the text box and its label to hide and the focus to move to a new formerly hidden text box[/li]
[li]You will type something into the second text box that will run a macro[/li]
[/ul]

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016