In Excel userform VBA, I want to add more activeX controls, specifically the
Calendar. However, when I right click "additional controls", nothing
happens. Also same response , nothing, when I do Tools additional
controls.
Excel 2003 with all updates & some 2002 rejected 'cus I don't have it
anymore.
Can put the calendar on a sheet. How to put on a form?
What am I missing?

Dan

You said "when I right click "additional controls",". Right click the form,
left click Additional Controls. If this doesn't work for you, a re-install
may be necessary. I have not found any settings in Office for "Additional
Controls" to be on or off.

Regards,

Alan


"DanR" wrote in message
...
In Excel userform VBA, I want to add more activeX controls, specifically
the Calendar. However, when I right click "additional controls", nothing
happens. Also same response , nothing, when I do Tools additional
controls.
Excel 2003 with all updates & some 2002 rejected 'cus I don't have it
anymore.
Can put the calendar on a sheet. How to put on a form?
What am I missing?

Dan

Ok, I repaired then uninstalled & installed Office Pro. Then installed ALL
updates.
Still get nothing when "Right click the form, left click Additional
Controls".
I did this: on another computer, made a new page containing the calendar
control & exported it. Then imported it to this PC. Works fine & now have
calendar avail. on this PC but still can't get "Right click the form, left
click Additional Controls".
Kind of a pain to run two computers to get one function!
Who knows what dll or other program runs the "Additional Controls" feature?
Something is obviously broken. I would like to get this fixed.

Dan




"Alan" wrote in message
...
You said "when I right click "additional controls",". Right click the
form, left click Additional Controls. If this doesn't work for you, a
re-install may be necessary. I have not found any settings in Office for
"Additional Controls" to be on or off.

Regards,

Alan


"DanR" wrote in message
...
In Excel userform VBA, I want to add more activeX controls, specifically
the Calendar. However, when I right click "additional controls", nothing
happens. Also same response , nothing, when I do Tools additional
controls.
Excel 2003 with all updates & some 2002 rejected 'cus I don't have it
anymore.
Can put the calendar on a sheet. How to put on a form?
What am I missing?

Dan

Hi Dan and Alan

I've got exactly the same problem, also reinstalled Office XP - also no Joy
Really hope Microsoft has an answer to this - been struggling with this for
ages.

My way was to use an old workbook that had all the new controls already
embedded and then work from there (I don't have the benefit of an additional
PC) but now I need to add a new control.....

Regards,
Herbert


"DanR" wrote:

Ok, I repaired then uninstalled & installed Office Pro. Then installed ALL
updates.
Still get nothing when "Right click the form, left click Additional
Controls".
I did this: on another computer, made a new page containing the calendar
control & exported it. Then imported it to this PC. Works fine & now have
calendar avail. on this PC but still can't get "Right click the form, left
click Additional Controls".
Kind of a pain to run two computers to get one function!
Who knows what dll or other program runs the "Additional Controls" feature?
Something is obviously broken. I would like to get this fixed.

Dan




"Alan" wrote in message
...
You said "when I right click "additional controls",". Right click the
form, left click Additional Controls. If this doesn't work for you, a
re-install may be necessary. I have not found any settings in Office for
"Additional Controls" to be on or off.

Regards,

Alan


"DanR" wrote in message
...
In Excel userform VBA, I want to add more activeX controls, specifically
the Calendar. However, when I right click "additional controls", nothing
happens. Also same response , nothing, when I do Tools additional
controls.
Excel 2003 with all updates & some 2002 rejected 'cus I don't have it
anymore.
Can put the calendar on a sheet. How to put on a form?
What am I missing?

Dan