Nigel Martin
Board Regular
- Joined
- Feb 17, 2002
- Messages
- 133
I am a total novice on UserForms. I have managed to create a UserForm that works with a TextBox and 2 CommandButtons on it. When I hit the enter key after typing a login pasword into the TextBox it highlights the OK CommandButton. How do I make the enter key do the same as clicking on the OK button ? Question 2 - I want a cell to say "Good Morning" if it is AM, "Good Afternoon" if it is PM and "Good Evening" if it is between 17:00 and 00:00 What formula do I need ?