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.

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.

I am not too familiar with VBA, what is Data Validation? Basically what I
have made is a short list of the next 6 mondays so users could see what they
were without having to look at a calander (they enter a monday to see the
next week of scheduled work) and I thought it might be easier if I could just
create a link so that when they click on the cell containing the monday they
want that it would copy that date to the cell they are now typing the date
in. I hope this helps explain, thanks!

"Vasant Nanavati" wrote:

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.

I really think Data Validation is the better approach here (no VBA
required!). With the target cell (the one in which the date woulld be typed)
active, go to the menu and use the following sequence:

Data | Validation | Allow: List | Source: (enter the range with the 6
Mondays) | OK.

Now when the user clicks on the dropdown arrow, he/she will be able to
select one of the Mondays in your list.
__________________________________________________ _____________________

"Josh Johansen" wrote in message
...
I am not too familiar with VBA, what is Data Validation? Basically what I
have made is a short list of the next 6 mondays so users could see what
they
were without having to look at a calander (they enter a monday to see the
next week of scheduled work) and I thought it might be easier if I could
just
create a link so that when they click on the cell containing the monday
they
want that it would copy that date to the cell they are now typing the date
in. I hope this helps explain, thanks!

"Vasant Nanavati" wrote:

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.

Awesome! Thanks so much!

"Vasant Nanavati" wrote:

I really think Data Validation is the better approach here (no VBA
required!). With the target cell (the one in which the date woulld be typed)
active, go to the menu and use the following sequence:

Data | Validation | Allow: List | Source: (enter the range with the 6
Mondays) | OK.

Now when the user clicks on the dropdown arrow, he/she will be able to
select one of the Mondays in your list.
__________________________________________________ _____________________

"Josh Johansen" wrote in message
...
I am not too familiar with VBA, what is Data Validation? Basically what I
have made is a short list of the next 6 mondays so users could see what
they
were without having to look at a calander (they enter a monday to see the
next week of scheduled work) and I thought it might be easier if I could
just
create a link so that when they click on the cell containing the monday
they
want that it would copy that date to the cell they are now typing the date
in. I hope this helps explain, thanks!

"Vasant Nanavati" wrote:

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.