Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control (Embeded) - Populate thru a command button
I have inserted a 'embedded' calendar control by going into 'more controls'
& choosing Calendar control 9.0. It works fine & I've even got it linked to a cell to show the dates chosen. I would want this Calendar popping up only when a command button is clicked. It just doesnt seem to work as there's no name for this calendar. I'm quite familiar with how this works with user forms but not with this embedded image. The name of the whole calendar appears as =EMBED("MSCAL.Calendar.7","") I usually use (formxxxx.show) to opening a user form, but this doesnt work in this situation with an embedded image. Appreciate any advice Thx, Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control (Embeded) - Populate thru a command button
Try something like
Worksheets("Sheet1").OLEObjects("Calendar1").Visib le = True ' OR Worksheets("Sheet1").OLEObjects("Calendar1").Visib le = False -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Matts" wrote in message ... I have inserted a 'embedded' calendar control by going into 'more controls' & choosing Calendar control 9.0. It works fine & I've even got it linked to a cell to show the dates chosen. I would want this Calendar popping up only when a command button is clicked. It just doesnt seem to work as there's no name for this calendar. I'm quite familiar with how this works with user forms but not with this embedded image. The name of the whole calendar appears as =EMBED("MSCAL.Calendar.7","") I usually use (formxxxx.show) to opening a user form, but this doesnt work in this situation with an embedded image. Appreciate any advice Thx, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate Cell Date Value with Active X Calendar Control | Excel Worksheet Functions | |||
Command Button Control Properties | Excel Discussion (Misc queries) | |||
Command Button from Control Toolbox | Excel Programming | |||
Can I launch the Calendar Control from a Comand Button | Excel Programming | |||
Command Button vs Control Button | Excel Programming |