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]

Take a look here http://www.fontstuff.com/excel/exltut02.htm and here http://www.fontstuff.com/vba/vbatut07.htm

 

[BGY23]

Hi, Try Data validation.

From the excel menu select Data > Validation. Put in your start and end dates. I believe excel makes users use the same format.

 

[baggers719]

thanks guys!

just trying the calendar option at the moment... however im struggling to find the control toolbar!!?? just not getting to grips with 2007 version lol..

any suggestions for finding this? i want to add a form..

thanks!

 

[VoG]

To add a form press ALT + F11 then select UserForm from the Insert menu.

Also, click the Office button, top left, click Excel Options, tick Show Developer tab on the Ribbon and click OK. This will give you access to macros, controls etc.

 

[baggers719]

hmmmm... im using excel 2007 and was attempting to add a calendar manually. however i cannot find "Calendar Control" in the dialog box. My version of office does not have MS Access. I sthere any way I can get hold of this add on???

 

[VoG]

You can get it here http://www.fontstuff.com/mailbag/qvba01.htm

The Excel 2003 version works with Excel 2007.

 

[baggers719]

ok i seem to have a working macro now that when i run this it will add the date to a selected cell.

is there a way of selecting a number of cells so that when I click a particular cell (e.g. in column B) it automatically bring the calendar up??

 

[VoG]

Assuming that you named the form frmCalendar as in the tutorial then right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 2 Then frmCalendar.Show
End Sub

then press ALT + Q to return to your sheet. The calendar should pop up when you click in column B.

 

[baggers719]

thanks for your help..

i have called the calender frmCalendar but it comes up with a the debug error and doesnt seem to like the the area "frmCalendar"

any suggestions???