I am trying to create a labor tracking timesheet. I would like to boxes that
you can click and drop down with certain information for you to pick from.
How do I do this? For example one box I need is for Codes and with that box
I would like to be able to pick between 4 different things. Then I would
like for the item I picked to automatically drop into the next available line
in excel.

Thanks

You don't need macros.

You can do this with Data Validation dropdowns and a VLOOKUP formula.

See Debra Dalgleish's site for more info on both.

http://www.contextures.on.ca/xlDataVal01.html

http://www.contextures.on.ca/xlFunctions02.html



Gord Dibben MS Excel MVP

On Fri, 22 Jan 2010 08:30:04 -0800, Andrea
wrote:

I am trying to create a labor tracking timesheet. I would like to boxes that
you can click and drop down with certain information for you to pick from.
How do I do this? For example one box I need is for Codes and with that box
I would like to be able to pick between 4 different things. Then I would
like for the item I picked to automatically drop into the next available line
in excel.

Thanks

Hi,
take a look at Debra web

http://contextures.com/xlUserForm01.html

"Andrea" wrote:

I am trying to create a labor tracking timesheet. I would like to boxes that
you can click and drop down with certain information for you to pick from.
How do I do this? For example one box I need is for Codes and with that box
I would like to be able to pick between 4 different things. Then I would
like for the item I picked to automatically drop into the next available line
in excel.

Thanks