Calendar ActixeX (Allow dates in a certain range)

amoore · Feb 25th, 2002, 06:41 AM

Please could someone advise me as to how one can go about restricting a Calandar ActiveX "LinkedCell" property to a certain range. E.g. I only want the LinkedCell property to put dates in the ActiveCell.Address() if it is within the range "D3:E16" (By way of example).

[ This Message was edited by: amoore on 2002-02-25 05:42 ]

Juan Pablo González · Feb 25th, 2002, 08:29 AM

Your explanation isn't very clear to me. Do you have a Calendar Control, using a Linked Cell, and you are returning dates to the active cell ? then, why are you using the Linked Cell ? If you're NOT using a Linked cell, then, care to post some code ?

amoore · Feb 25th, 2002, 10:52 PM

In answer to you question. I want to populate a range of cells with dates using a calendar control. However, if the active cell falls outside of that range. The calander control must not be allowed to populate thar particular cell. Hope this makes things clearer.

Feb 25th, 2002, 08:29 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Your explanation isn't very clear to me. Do you have a Calendar Control, using a Linked Cell, and you are returning dates to the active cell ? then, why are you using the Linked Cell ? If you're NOT using a Linked cell, then, care to post some code ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 06:41 AM	#1
amoore New Member Join Date: Feb 2002 Posts: 2	Please could someone advise me as to how one can go about restricting a Calandar ActiveX "LinkedCell" property to a certain range. E.g. I only want the LinkedCell property to put dates in the ActiveCell.Address() if it is within the range "D3:E16" (By way of example). [ This Message was edited by: amoore on 2002-02-25 05:42 ]

Feb 25th, 2002, 10:52 PM	#3
amoore New Member Join Date: Feb 2002 Posts: 2	In answer to you question. I want to populate a range of cells with dates using a calendar control. However, if the active cell falls outside of that range. The calander control must not be allowed to populate thar particular cell. Hope this makes things clearer.