Link control to Excel cell to click a day in month to return date
 

I want to link a Control to an Excel cell. When I click the control (e.g.
maybe a square date box or down arrow as in Validate) I want to see at top a
changeable "YEAR" and "MONTH" and below it, by week, the weekdays for "YEAR"
and "MONTH". Once I have selected the "YEAR" and "MONTH" I need, I click a
day of the week and the control must then insert the date (for selected
"DAY", "MONTH" and "YEAR") in the cell that is linked to the control.

Link control to Excel cell to click a day in month to return date
 

You may want to check out Ron de Bruin's pop up calendar


Calendar on the page - pop-up version
http://www.rondebruin.nl/calendar.htm



"Janas in RSA" wrote:

I want to link a Control to an Excel cell. When I click the control (e.g.
maybe a square date box or down arrow as in Validate) I want to see at top a
changeable "YEAR" and "MONTH" and below it, by week, the weekdays for "YEAR"
and "MONTH". Once I have selected the "YEAR" and "MONTH" I need, I click a
day of the week and the control must then insert the date (for selected
"DAY", "MONTH" and "YEAR") in the cell that is linked to the control.

Link control to Excel cell to click a day in month to return d
 

Thank you - I see the calendar - what I need is once I have the year and
month needed on the calendar, I want to click a day and the calendar must
disappear and the seleted day, month and year must be present in the cell -
similar to the "Validate" function where you can select an item and it
appears in the cell.

"Duke Carey" wrote:

You may want to check out Ron de Bruin's pop up calendar


Calendar on the page - pop-up version
http://www.rondebruin.nl/calendar.htm



"Janas in RSA" wrote:

I want to link a Control to an Excel cell. When I click the control (e.g.
maybe a square date box or down arrow as in Validate) I want to see at top a
changeable "YEAR" and "MONTH" and below it, by week, the weekdays for "YEAR"
and "MONTH". Once I have selected the "YEAR" and "MONTH" I need, I click a
day of the week and the control must then insert the date (for selected
"DAY", "MONTH" and "YEAR") in the cell that is linked to the control.

Link control to Excel cell to click a day in month to return d
 

Read the info on the page below the code


Tip 2: If you want that the calendar disappear when you click on a date in the control you have two options.

After ActiveCell.Select in the Calendar_Click event add this line.
Calendar1.Visible = False

Or select a cell next to the date cell, Replace ActiveCell.Select for:
ActiveCell.Offset(0, 1).Select


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Janas in RSA" wrote in message ...
Thank you - I see the calendar - what I need is once I have the year and
month needed on the calendar, I want to click a day and the calendar must
disappear and the seleted day, month and year must be present in the cell -
similar to the "Validate" function where you can select an item and it
appears in the cell.

"Duke Carey" wrote:

You may want to check out Ron de Bruin's pop up calendar


Calendar on the page - pop-up version
http://www.rondebruin.nl/calendar.htm



"Janas in RSA" wrote:

I want to link a Control to an Excel cell. When I click the control (e.g.
maybe a square date box or down arrow as in Validate) I want to see at top a
changeable "YEAR" and "MONTH" and below it, by week, the weekdays for "YEAR"
and "MONTH". Once I have selected the "YEAR" and "MONTH" I need, I click a
day of the week and the control must then insert the date (for selected
"DAY", "MONTH" and "YEAR") in the cell that is linked to the control.