Populating a Date-formatted Cell with ActiveX Calendar Control

  • Thread starter Thread starter Jim Lawrence
  • Start date Start date
J

Jim Lawrence

Can anyone share with me how to click in a cell and have the calendar open,
and populate the cell with the calendar value you select?
 
Probably your best option will be to embed a Date & Time Picker Control into
your spreadsheet.

Bring up the Control Toolbox.
Click on the More Controls button (Hammer and Wrench)
Select Microsoft Date and Time Picker Control
Draw the control over top of the cell you want.
Right click the control and select Properties
In the linked cell property add the cell reference
 
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

Find Date cell using Calendar Control 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to run a macro upon a cell click 3
Make 1 UserForm macro target different predefined cells 2
Put Value in a cell next to the active cell 1
Calendar staying open 6
Populate Cell Date Value with Active X Calendar Control 1
Monthly Calendar Form 3

Back
Top