Too many ActiveX?

mrroland

Active Member
Joined
Apr 29, 2002
Messages
294
Hi,

Not really a question i guess but am looking for some advise.

I am trying to set up a worksheet that will act as a repair form. Basically the users what a tick box to indicate the status of the product. Adding up all the different scenarios i would have to insert about a 170+ ActiveX contols as the tick boxes also have to be contolled by VBA.

I once read somewhere on this board that too many AcitveX controls can lead to unexpected behaviour of the spreadsheet. Is this correct?

I would gladly use the tickbox from the form toolbar but it is not possible to control this thing with VBA (correct???)

Any advice is welcome

Cheers,
Roland
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,303
Office Version
  1. 365
Platform
  1. Windows
Roland

Both types of checkbox can be manipulated using VBA.

It just really depends what you want to do.

Mind you I would ask why you need/want 170 checkboxes in the first place.:)
 

mrroland

Active Member
Joined
Apr 29, 2002
Messages
294
Hi Norie,

I am a bit cautious about these 170 as well :biggrin:

Currently i have formatted the cell and if a product is (for example) scrap than i inserted an "x" in front of it. The user prefers if i would use a checkbox (looks better). Before i even go this way i just want to be sure that it can be done and want to have a indication of how much work that will be.

You say that the tick boxes from the form toolbar can also manipulated through VBA. Can you give me an example?

I guess that the tick boxes from the forms toolbar are more "stable" than the one from the control toolbox. Or, in your opinion, it doesn't really matter?

Appreciate your advice

Cheers,
Roland
 

Forum statistics

Threads
1,141,587
Messages
5,707,238
Members
421,498
Latest member
matinebi

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