Calendar drop-down list

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Guil

Thread Starter
Joined
Sep 16, 2004
Messages
6
I am using Office 2003. I would like to create, in a cell, a calendar drop-down list.

The specific field is about the date the user gets started to fill the worksheet.

After picking up the date from a nice calendar, the date should appear in the cell.

Thank you for any and all advice and direction.
 
Joined
Aug 17, 2003
Messages
17,584
"using Office 2003"....

Is the cell in a Word table, in an Excel spreadsheet or ...?

Office 2003 is not an application, its a suite of applications.
Knowing which one would help.
 

Guil

Thread Starter
Joined
Sep 16, 2004
Messages
6
Brilliant! Thanks Dreamboat very much! But, I don't wanna work within ranges.

To perfect fit in my purposes, How can i specify in the code so the calendar pops up just in certain cells, predefined by me, instead of assigning a range to work with?

Another question: How can I set up a cell so as soon as I select it a nearby comment box pops up?
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
"Another question:"
You can place a comment in any cell. You can then MOVE that comment box where you want it to come up.

As for popping up an activex control right from the spreadsheet? No clue. :(
 

Guil

Thread Starter
Joined
Sep 16, 2004
Messages
6
Sorry i didn´t make myself clear in the second question.

I would like that the comments attached in cells do not disappear when you put the mouse out of the cell borders and how i should do to get rid of those comment box / cell line connectors?

Many thanks in advance.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top