help w/ code in macro

  • Thread starter Thread starter -Brian-H-
  • Start date Start date
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
 
Hi Brian

You don't have to select the cell
Range("L1").Value = Calendar1.Value
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calendar Control in UserForm 1
Help to create a macro 2
if worksheet visible - calendar form 4
Pop Calendar in User Form 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Passing a value from one form to another 2
Advance Macro help 2
Prevent drop-down of combo box 5

Back
Top