non showing Components in Component Addin window.

SteveGoodman

New Member
Joined
Sep 19, 2002
Messages
41
Any idea how I can add a component to the toolbox when it is not listed in the component add-in window.

I can see the OCX file from within VB, but when I try to find it in Excel it does not show it or allow me to browse to the OCX. The OCX has been registered and so Windows does know about it.

What can I do to sort this out?

Cheers

Steve.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

s-o-s

Active Member
Joined
Apr 14, 2002
Messages
384
Steve,

I don't know too much about it but have you tried checking to see if the application object has been enabled in the Visual Basic Tools | References section, click help on the pop up box.

Once when I had a problem similar to the one you are describing I was asked to also check the Microsoft Visual Basic for Applications Extensibility 5.3 button. This solved my problem...Hope it works also for you if its more involved than that you help goes beyond my abilities.
 

SteveGoodman

New Member
Joined
Sep 19, 2002
Messages
41
cheers for the help, problem sorted it was appearing somewhere in the middle of the components list with a different name to the one displayed in VB editor.

Only found this by going through each option in turn looking for the ocx name.
 

s-o-s

Active Member
Joined
Apr 14, 2002
Messages
384
On 2002-10-16 09:13, SteveGoodman wrote:
cheers for the help, problem sorted it was appearing somewhere in the middle of the components list with a different name to the one displayed in VB editor.

Only found this by going through each option in turn looking for the ocx name.

Don't you just love Microsoft !!! :wink:

Glad you got it sorted :)
 

Forum statistics

Threads
1,144,510
Messages
5,724,787
Members
422,579
Latest member
Lekha mohanty

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top