Userform to accept input from textbox after "return" is pressed

**welchs101** · 10-11-2012, 06:51 AM

I have created a userform designed to accept the password from the user. I went with the userform because this way when the user types in the password it appears on the screen as "*******" so you dont actually see the password being typed in.

I am not an expert on userforms and i have a question:

After user types in text into userform and they hit the return button i want this to accept the users input...........but instead pressing return just highlights the "OK" button. Any ideas?

I am attaching the macro i have at this point. to execute goto first page of workbook and press the "View Report" button.

**welchs101** · 10-11-2012, 06:59 AM

ok. i should have done some additional searching before posting my answer but basically what i did to get enter to accept the input is this.......

and this worked.

***************************************************************
Change the "Default" property of the command button to True.

You should see the properties window on the left of the VBA editor. If not, press F4.

Click on the button

Find the property called Default. It will say False.

Double click it to change it to True.

Now, pressing Enter will run the button's code.

**************************************************************

Userform to accept input from textbox after "return" is pressed

LinkBack

Thread Tools

Rate This Thread

Display

Userform to accept input from textbox after "return" is pressed

Re: Userform to accept input from textbox after "return" is pressed

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions