C
Colin Raven
Hi all!!
I just discovered the MonthView control for selecting a date, it looks _so_
useful, and was well worth the search.
B.U.T. (there's always a "but"!)
How can I make the control visible only when a user clicks into that
particular cell?? (In other words a "drop down" ??)
I searched the control properties, played with almost every single relevant
sounding value but couldn't find what to change in order to enable only
"on-click" visibility. Not having any VBA knowledge doesn't help either I
guess.
Here's what I did so far, perhaps someone can take a look and see what I'm
either doing wrong, or else failing to do at all.
1. Choose a cell where the desired "drop down calender" will reside
2. View | Toolbars |Visual Basic | Control Toolbox | More Controls
3. Choose "Microsoft MonthView Control 6.0 (SP4)"
4. Plant it in the chosen cell described in 1. above, size accordingly
5. [???????] [??????] to make it "OnClick visible"
Some reading brought me to an article which seemed to suggest that I should
*first* insert a text box in the cell (prior to inserting the control
apparently), but that didn't change the outcome.
Guidance, suggestions and opinions would all be greatly appreciated.
Regards to all & TIA,
-Colin
I just discovered the MonthView control for selecting a date, it looks _so_
useful, and was well worth the search.
B.U.T. (there's always a "but"!)
How can I make the control visible only when a user clicks into that
particular cell?? (In other words a "drop down" ??)
I searched the control properties, played with almost every single relevant
sounding value but couldn't find what to change in order to enable only
"on-click" visibility. Not having any VBA knowledge doesn't help either I
guess.
Here's what I did so far, perhaps someone can take a look and see what I'm
either doing wrong, or else failing to do at all.
1. Choose a cell where the desired "drop down calender" will reside
2. View | Toolbars |Visual Basic | Control Toolbox | More Controls
3. Choose "Microsoft MonthView Control 6.0 (SP4)"
4. Plant it in the chosen cell described in 1. above, size accordingly
5. [???????] [??????] to make it "OnClick visible"
Some reading brought me to an article which seemed to suggest that I should
*first* insert a text box in the cell (prior to inserting the control
apparently), but that didn't change the outcome.
Guidance, suggestions and opinions would all be greatly appreciated.
Regards to all & TIA,
-Colin