Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a MsgBox to alert user an invalid entry has been mad
I have built a User Form that asks for an employee ID number to be entered.
That data then goes to cell A2 on the spreadsheet. Cell A1 has a VLOOKUP formula that goes to another sheet and finds that employee ID number and returns the name to cell A1. If it can't find the ID number then #N/A returns in cell A1. I want to create a message box that will pop up after the user types an invalid number in the User Form indicating "Invalid Employee Number". How can I do that? Also, I know this sound s extremely simple, but being new to this I am unsure. The code for the above message box, where do I insert that? I assume in the code for the User Form? Thanks so much for any assistance! Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error alert for invalid date | Excel Worksheet Functions | |||
Error Alert for Invalid Data doesn't work for data selected in col | Excel Worksheet Functions | |||
How do I add an alert message upon a user closing the workbook? | Excel Discussion (Misc queries) | |||
Can Excel alert me to a duplicate entry? | Excel Discussion (Misc queries) | |||
Data Entry Alert in User Form | Excel Discussion (Misc queries) |