adding dates via a calendar???

[baggers719]

Hi all,

I'm trying to limit the information people can put into my format and therefore to ensure they put in a the correct date etc i'm wondering if it is possible to have a calendar pop up to click on the date for a particular cell??

is this an easy thing to do??? im open to any suggestions also!

thanks,

Sean

 

[VoG]

It is actually the whole user form that should be called frmCalendar, not the calendar itself.

In design mode click the top bar of the user form - what name is displayed in the Properties window?

 

[baggers719]

looks to me like the form is called "frmCalendar"

when i click on the calendar itself this is named "Calendar1"

 

[VoG]

What is the error message and what line of code is highlighted when you click the Debug button?

 

[baggers719]

error message 404...

and the text frmCalendar.Show is highlighted yellow from the text you gave me.

when i hover the mouse cursor over it says "frmCalendar = Empty"

I have created frmCalendar in a separate xls worksheet as inthe instructions called PERSONAL.XLSB. im not sure what othr information will help?

i right clicked on the worksheet in the file I wanted to use as you stated and pasted the code on that sheet? i think i did this right?

 

[VoG]

Try this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 2 Then Application.Run "personal.xlsb!Open_Calendar"
End Sub

This assumes that you added the Open_Calendar code from the tutorial.

 

[baggers719]

great!! seems to work.. I just had to remove the underscore you put in tyhe coding...

thank you so much for your help!