Would Data Validation work for you?
__________________________________________________ ______________________

"Josh Johansen" wrote in message
...
I have a list of the next six mondays that I allow a user to see and I want
them to be able to click on any of those 6 cells to display that date into
a
different cell that I am using for calculations. As it is now I have them
typing in the date manually by using the 6 listed mondays before to make
sure
they choose a monday. How can I generate a hyperlink or command button so
that when they click on the monday they want, it is automatically inserted
into the cell. Thank you.