Inserting calendar into a sheet?

Hi,

I've got the calendar to work by right clicking in a cell and selecting insert date, however I'd like the calendar to pop up when a cell is clicked on.

Any ideas on how it can be done?

Hi Gaz Carr...

have you got an example of your workbook??

Try this.

Nothing to complicated just has to be 'user friendly'.

i havent got the calendar object installed on this machine as im at work....

i would have thought that you could do something in the SheetSelectionChange event.

mayb a bit like this:

Please Login or Register  to view this content.

that way everytime a cell is clicked it will show the calandar but if you only want it to happen for cells in a certain column you could do

Please Login or Register  to view this content.

That would make it only happen for cells in B2:B65536. But sorry mate i dont know the bit you really wanted to know...

Any1 else know it??

I'd had a read through before posting on here but doesnt appear to tell me how to launch the calendar automatically by selecting a certain cell. Thanks for the link though

Originally Posted by Stuie

That would make it only happen for cells in B2:B65536. But sorry mate i dont know the bit you really wanted to know...

Any1 else know it??

Looks like I could maybe amend so that it worked for me. cheers

yea im sure if you tweak it and amend it a bit it then it will work out eventually

Oh you wanted the calandar form to show???

Wonderfull mate! Just what I was after. Much appreciated.

yes stuie, sorry maybe my description was a little brief.