MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sheet selection for inputed data in InputBox

Posted by Brad on July 02, 2001 11:33 AM

I am trying to make an input box where the user pushes a button and it runs the macro and prompts the user to enter the hours an employee worked. There is a sheet for each employee (First name Last name) and I need a way for the user to select, from a list preferably, of available sheets to enter the data in.

In addition, I would need the sheet to be able to go to the end of column C where the first blank cell is to enter the data.


Posted by mseyf on July 02, 2001 1:32 PM


John Walkenbach has some code some his site that you may be able to adopt to your needs.