911Kid
New Member
Hello,
I was wondering if it is at all possible to use the Input message box that shows up with any cell that is clicked part of the Data Validation to do a vlookup on another sheet in the same workbook to return the name and last name of the employee id in the selected cell..
Just to give a general overview of the request, I work on a monthly bonus adjustment file which has many worksheets and each worksheet I want to be able to click on a cell that has an EmpID, which is always a 6 digit number formatted as text such as 612542 or 001245, etc..., and when I click on the cell, I want the input message box to pop up and display the name and last name of the selected cells EmpID by doing a look up from another worksheet in the same workbook. The input message will show until I click on another part of the sheet which will make the pop up input message to go away.
I was wondering if it is at all possible to use the Input message box that shows up with any cell that is clicked part of the Data Validation to do a vlookup on another sheet in the same workbook to return the name and last name of the employee id in the selected cell..
Just to give a general overview of the request, I work on a monthly bonus adjustment file which has many worksheets and each worksheet I want to be able to click on a cell that has an EmpID, which is always a 6 digit number formatted as text such as 612542 or 001245, etc..., and when I click on the cell, I want the input message box to pop up and display the name and last name of the selected cells EmpID by doing a look up from another worksheet in the same workbook. The input message will show until I click on another part of the sheet which will make the pop up input message to go away.