dave.bangert
New Member
- Joined
- Nov 14, 2009
- Messages
- 9
I have several date inputs in some of my excel sheets. I would like to add a drop down calendar for these cells. How to proceed?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Best way to add drop down calendar
- Thread starter dave.bangert
- Start date
Excel Facts
What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
VoG
Legend
- Joined
- Jun 19, 2002
- Messages
- 63,650
This may help http://www.fontstuff.com/vba/vbatut07.htm
Upvote
0
Alee Aasim
New Member
- Joined
- Nov 3, 2009
- Messages
- 21
Press Alt + D then L to open data validation window then Allow select List under source window put the reference of your data range click ok.
across the sheet if your need to insert drop down you need to assign name to your data then call it in data validation list.
regs,
aasim
across the sheet if your need to insert drop down you need to assign name to your data then call it in data validation list.
regs,
aasim
Upvote
0
Similar threads
- Question
- Question
