LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Calendar Control Linked Cell

Let's say my CalendarControl LinkedCell is F7. My macro selects column F and
inserts a column. This makes the LinkedCell property of my Calendar go to
#REF!. I would like to re-program it back to cell F7 after having inserted
my column. Of course, Calendar.LinkedCell = F7 would do it, ....but I get an
error message cause I cannot find the property "LinkedCell" for the Calendar
object.
How do I go about it ?

Thanks in advance for your kind help
Marc
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate Cell Date Value with Active X Calendar Control Jim Lawrence Excel Worksheet Functions 1 February 13th 09 04:20 PM
Jump to cell based on cell results created by calendar control too JB Excel Discussion (Misc queries) 3 January 15th 08 08:18 PM
How to insert date using a pop up calendar control in a cell i Sunnyskies Excel Discussion (Misc queries) 0 October 16th 06 09:16 AM
Calendar control on cell enter? OmegaMan Excel Worksheet Functions 1 July 7th 06 09:02 PM
How to insert date using a pop up calendar control in a cell i Iain the scout Excel Discussion (Misc queries) 4 December 17th 05 08:10 PM


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"