Excel 2007 : [SOLVED] Simple List Box

[Jeff Hejl]

I wanted a basic spreadsheet for tracking hours weekly. I thought it would be simple to have a 'Time In' & 'Time Out' column, and the rows for the columns would be each day of the week. I wanted to have a list box in each cell to select the time in and out, then have those times formulate into another cell that would return the amount of hours oer day (minus lunch hour).

With List (form) Box I see that you can pick a set of data ranges to have in your box. Now I do not understand how I tie certain cells to that box or which cells I shold be tieing together. Please make suggestions, thank you.

Jeff

[protonLeah]

Right click the control,
-->Format control
------>Control tab
---------->cell link box...