help w/ code in macro

B

-Brian-H-

I have a calendar control that sets the date in a specific cell. Befor
I open "frmcalendar" I have to select the date cell. How can I appen
my "click" event code in frmcalendar, to automatically moving th
focus to the date cell [L1], before filling in the date?

as it is now the cal control opens via a button...would it be better t
place the code in this macro
 
R

Ron de Bruin

Hi Brian

You don't have to select the cell
Range("L1").Value = Calendar1.Value
 
Top