Cell Click Pop Up Calendar

[pluce]

I have gone through the coding and now have the option to select a cell, right click, select "Insert Date" and then select a date from the pop-up calendar that...pops up.... The date is then input into that cell.

I need to know now how to format that specific cell to pop up that calendar as soon as it is selected so that users can only utilize that cell for that purpose. Does anyone know how to do this. I was thinking in the UserForm I could just tag the associated cell...but that does nothing...Help!

 

[James006]

Hi pluce,

You can easily format your date, for example :

Format(yourdate, "dd mmmm yy")

HTH

 

[pluce]

The date is already formatted correctly once it is selected. The problem is how the date is selected. Currently you have to right click on the cell, select "Insert Date", and then select the date you want which appears in the correct format. I would like to just select th cell (left click) and have the calendar pop up immediately. No right click, no selecting the calendar from a menu. I want the calendar to be the only option for that cell, select the cell and the calendar pops up.

Hi pluce,

You can easily format your date, for example :

Format(yourdate, "dd mmmm yy")

HTH

 

[VoG]

Maybe something like this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(False, False) = "A1" Then UserForm1.Show
End Sub