Additional controls to Toolbox

[DanR]

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

 

[Alan]

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]

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

 

[Guest]

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