Pop Up Calendar

[Hoopsah]

Hi,

I have written an Excel Spreadsheet which, when the user clicks on a cell a Pop Up Calendar appears and allows the user to click on a date which will then populate the field.

It works perfectly on my machine, however, if I use someone elses machine it comes up with an error message and takes me into Visual Basic Editor.

Am I missing something? Is there something I can change to allow it to work from other stations?

 

[Richard Schollar]

It depends how you are creating that calendar - if it is an ActiveX control then quite possibly they don't have it installed on their machine.

 

[ADAMC]

Step 2 might help:

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

 

[VoG]

Possibly missing the Calendar Control http://www.fontstuff.com/mailbag/qvba01.htm

 

[Hoopsah]

Cheers Guys,

I think that will probably solve it.

D'Oh!!