My current macro asks the user for the employee ID takes the user to the row that contains that employee ID then stops. The cell it stops on contains a drop down box.
How do I get the macro to continue and display the drop down menu, allow the user to make a selection from a list of five options, then move the cursor a number of cells to the right based on the menu item selected?
Thanks.
How do I get the macro to continue and display the drop down menu, allow the user to make a selection from a list of five options, then move the cursor a number of cells to the right based on the menu item selected?
Thanks.