Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Date list box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 22 Oct 2007 16:35 GMT
Hi

Is it possible to put something similar to a list box that has a drop
down menu in a spreadsheet? It would have a calendar option that a
date can be selected? Something similar to an online travel company
that enables you to chose a date of depature

TIA
Steve
Gord Dibben - 22 Oct 2007 17:33 GMT
Steve

See Ron de Bruin's site for use of the calendar control.

http://www.rondebruin.nl/calendar.htm

Gord Dibben  MS Excel MVP

>Hi
>
[quoted text clipped - 5 lines]
>TIA
>Steve
Steve - 23 Oct 2007 19:31 GMT
Thanks for the reply
I've just been through the tutorial and found it really interesting as
I've never done anything in VBA before.
I got a bit stuck towards the end as I was trying to add the Custom
Menu Item to my toolbar that appears when I right click on the
spreadsheet
Holding and dragging the custom menu doesn't let me right click on the
screen to open the toolbar that I want
I have no problems adding it to the toolbars at the top of the screen,
but I would find it easier if I could right click on the screen and
select it from there. On the calendar that can be downloaded from the
website it's available with the right click toolbar

Any suggestions how I can do it

TIA
Steve

> Steve
>
[quoted text clipped - 15 lines]
>
> - Show quoted text -
Bernard Liengme - 22 Oct 2007 17:36 GMT
Have a look at data Validation
You need a list of values (dates in your case) elsewhere on the same sheet
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi
>
[quoted text clipped - 5 lines]
> TIA
> Steve

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.