Combo into calender?

[calculus87]

Hello,
Here is what I am trying to do. In Excel, Create a combo box, bu
instead of it droping down into a list, it drops down into a calender.

After the user selects the date that he/she desires, the date appear
in a cell.

I hope I have made myself clear enough. If not let me know. Thank

 

[Ron de Bruin]

Maybe you like this

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

 

[calculus87]

Hello,
I appologize for my delay in responding.
Thank you for giving an answer to my question. I am have a littl
problem with it though. I have done everything that is stated on th
web site, but I receive a error on this line

Calendar1.Left = Target.Left + Target.Width - Calendar1.Width

The debugger says "Run time error 424 Object Required"

Any thoughts? Thank

 

[Ron de Bruin]

Hi

Calendar1 is the name of the Calendar
Maybe your name is different?

 

[calculus87]

Hey,
Thank you for your responses.
I found a link on the Microsoft website which had this code and wa
able to help me. Thanks

Sub Menu_Create()
Dim myMnu As Object
Set myMnu = CommandBars("Worksheet menu bar").Controls. _
Add(Type:=msoControlPopup, before:=3)
With myMnu
' The "&" denotes a shortcut key assignment (Alt+M in this case).
.Caption = "jkhgkjhgjhgkhg"
End With
End Sub

The web site was
http://support.microsoft.com/defaul...502&Product=xlw

Thank

 

[calculus87]

Everything is default on my computer. If I was to look for the name o
the calender, where would I look? Thank

 

[Ron de Bruin]

Sub Menu_Create()
???

After the user selects the date that he/she desires, the date appears in a cell.

I thought we are talking about a Calendar?

 

[Ron de Bruin]

In the Design mode select the Calendar.
(Press the Design mode button on the contol toolbox)

You can see the name now in the Formulabar(left side)

 

[calculus87]

Yah, I have two questions going at once and I posted an incorrect post.

Anyways, I figured out my problem. Thanks, so much for your help

 

[Ron de Bruin]

You are welcome