Is anyone willing to take a look at my excel workbook and tell me what I'm
doing wrong? I've followed the steps at www.fontstuff.com but I'm having no
luck getting the calendar to pop-up when I click on a specific cell.

Thanks,

Tia

Hi,

I'm sure that if you upload your workbook to the site below and post the
link then someone will help

http://www.savefile.com/

Mike

"Tia" wrote:

Is anyone willing to take a look at my excel workbook and tell me what I'm
doing wrong? I've followed the steps at www.fontstuff.com but I'm having no
luck getting the calendar to pop-up when I click on a specific cell.

Thanks,

Tia

http://www.savefile.com/files/1927672

"Mike H" wrote:

Hi,

I'm sure that if you upload your workbook to the site below and post the
link then someone will help

http://www.savefile.com/

Mike

"Tia" wrote:

Is anyone willing to take a look at my excel workbook and tell me what I'm
doing wrong? I've followed the steps at www.fontstuff.com but I'm having no
luck getting the calendar to pop-up when I click on a specific cell.

Thanks,

Tia

Hi,

File is fixed here

http://www.savefile.com/files/1927731

I just noticed your using Excel 97 and I only have 2003 so if you can't open
it then post again and I'll post help on how to do it

Mike

"Tia" wrote:

http://www.savefile.com/files/1927672

"Mike H" wrote:

Hi,

I'm sure that if you upload your workbook to the site below and post the
link then someone will help

http://www.savefile.com/

Mike

"Tia" wrote:

Is anyone willing to take a look at my excel workbook and tell me what I'm
doing wrong? I've followed the steps at www.fontstuff.com but I'm having no
luck getting the calendar to pop-up when I click on a specific cell.

Thanks,

Tia

It works, but for some reason the dates on the calendar aren't showing up.


"Mike H" wrote:

Hi,

File is fixed here

http://www.savefile.com/files/1927731

I just noticed your using Excel 97 and I only have 2003 so if you can't open
it then post again and I'll post help on how to do it

Mike

"Tia" wrote:

http://www.savefile.com/files/1927672

"Mike H" wrote:

Hi,

I'm sure that if you upload your workbook to the site below and post the
link then someone will help

http://www.savefile.com/

Mike

"Tia" wrote:

Is anyone willing to take a look at my excel workbook and tell me what I'm
doing wrong? I've followed the steps at www.fontstuff.com but I'm having no
luck getting the calendar to pop-up when I click on a specific cell.

Thanks,

Tia

Hi,

It's probably because of my later version of excel. Open VB editor and
double click the userform i created and delete the calendar from the userform.

With the userform selected click
View|Toolbox and see if you have a calendar control in the toolbox. If you
have click it and drag a calendar to the same size as the userform. You
should now be OK.

If you haven't got a calendar control click TOOLS-Additional controls and
scroll down until you find

Calendar Control x
X could be any number up to (I think) 12
Check the checkbox then OK and you should now have a calendar control in
your toolbox to put on the userform.

Mike





"Tia" wrote:


It works, but for some reason the dates on the calendar aren't showing up.


"Mike H" wrote:

Hi,

File is fixed here

http://www.savefile.com/files/1927731

I just noticed your using Excel 97 and I only have 2003 so if you can't open
it then post again and I'll post help on how to do it

Mike

"Tia" wrote:

http://www.savefile.com/files/1927672

"Mike H" wrote:

Hi,

I'm sure that if you upload your workbook to the site below and post the
link then someone will help

http://www.savefile.com/

Mike

"Tia" wrote:

Is anyone willing to take a look at my excel workbook and tell me what I'm
doing wrong? I've followed the steps at www.fontstuff.com but I'm having no
luck getting the calendar to pop-up when I click on a specific cell.

Thanks,

Tia