help with calendar

[bam12]

I have workbook made and everything looks good. I have created a popup calendar. I want to assign it to pop up when 6 cells are clicked on.

This is where the problem is, i cant figure that part out.

I ahve crated the calendat is the personal.xls folder, could this be the problem

thanks in advance for any help

 

[bam12]

code

I need code so that when the above mentioned 6 cells are clicked on the calendar pops up.

cell are a16, h16, h47,h48,h49, h51

Thanks for any help

 

[bam12]

help

is this possible

 

[Legacy 98055]

Are you speaking of the MS Calendar Control? What is your calendar???

 

[bam12]

yes

yes using microsoft calendar control

I have the spreadsheet made up and the calendar

i saw an example on net that when click on cell the calendar popped up and you clicked on day and it placed that date in the cell.

Have the code from it but cant figure out how they did it

 

[Legacy 98055]

I posted something a long time ago. Give me a second and I'll see if I can dig it up...

 

[bam12]

ok

thanks right click

 

[Legacy 98055]

Here's a couple and there are others as well. Do a search and post back if you cannot get what you need there.

http://www.mrexcel.com/board2/viewtopic.php?t=66668&highlight=calender+calendar+control

http://www.mrexcel.com/board2/viewtopic.php?t=15390

 

[bam12]

help

still need help

 

[Legacy 98055]

Please discern the difference between "I need help" and "I want somebody to do some free work for me." If you can read English, you will find plenty of background using search.