date pop-up

[cheveley]

there was a helluva good post last week on a popup which allowed one to insert the date for a cell through a pop-up. my problem i cant find the post.

anyone perhaps have a link?

thanks.

 

[erik.van.geit]

Hello,
didn't find anything within last 2 weeks searching for "data popup insert ...."
what would you like to do ?

kind regards,
Erik

 

[venkat1926]

http://www.fontstuff.com/vba/vbatut07.htm

 

[cheveley]

hi erik

i was thinking more a "nice to have" rather than a "must have" but if it is no trouble;

instead of inserting a date manually, is there a way in which a pop-up appears and allows one to select the appropriate date from a calender. sometimes this is easier for users to use because they get the date format wrong.

thanks

 

[cheveley]

thanks venkat1926

 

[erik.van.geit]

perhaps you meant this thread
http://www.mrexcel.com/board2/viewtopic.php?t=176307

About calendar tushar has some stuff
http://www.tushar-mehta.com/excel/template_calendar.html
http://www.tushar-mehta.com/excel/software/vba_calendar/

this links can be usefull too
http://www.fontstuff.com/vba/vbatut07.htm

all this will probably get you started
best regards,
Erik

 

[cheveley]

thanks erik, will check out the links