Need help with my ActiveX controllers

[AdamDavidSzocs]

Hey folks!

Please help me out, this is going on my nerves.

I'm making an excel sheet for my shop. I want to register orders on this one.

I'm attaching a file, you might see it's quite large, working a bit slow. I've got 400 rows here, each with some checkboxes with their own functions. When putting a tick to a box,
date of order, date when the case was closed, etc.

I have 1200 checboxes now, all together. Quite a lot, I know that, that is making the sheet working slow, but that's no problem. I'm quite dumb at excel, this was the only way I could solve this.

The problem is this:

I want to add antother 400 buttons, one in each row. On clicking, it would automatically send an email to the customer, no phonecalls were required.

If I add 7 more buttons (I prefer togglebuttons) worksheet still works fine. At the point of adding the eighth one or any more, my existing and working checkboxes stop working.

Why does that happen? Is there a limit on number activex controls? Why does the 1208th box kill all the others?

here's the file: https://www.dropbox.com/s/1737gw7f5a...0ENG.xlsm?dl=0

Thanks in advance

Adam

[JasperD]

you link doesn't work.

And - 1200 checkboxes sounds like idiocracy

[AdamDavidSzocs]

I know that, but thats as many as I need, that's it.

link:

https://www.dropbox.com/s/1737gw7f5a...0ENG.xlsm?dl=0

[AdamDavidSzocs]

...and it was the only way I could solve this.

[JasperD]

I think you're able to achieve the same by removing all checkboxes.

Example:
- Remove all checkboxes from column F.
In the direct code window, type the following:

Please Login or Register  to view this content.

Then add the following code to your worksheet and double click on the "checkboxes" to change their state

Please Login or Register  to view this content.

This seems to do exactly the same as you tried to achieve with 400 checkboxes.
You can apply the same logic on the other columns with checkboxes.

[JasperD]

Oh and in the same way, you would be able to remove those hundreds of conditional formatting rules that you have in there and just do it based on the changing cell row/column...

[AdamDavidSzocs]

I'll try theese, thanks

[AdamDavidSzocs]

Mind if I ask what and where the direct code window is?

Sorry, I'm too stupid for excel.

[AdamDavidSzocs]

Never mind, I figured out, I think.

This solution seems okay, thanks. Though, if I'd still like to stick to my own sluggy spreadsheet... Any clue on what is the reason of the 1208th checkbox, killing all the others?

[JasperD]

Hi,

I don't know and honestly can't understand why you'd want to stick with using 1200+ checkboxes, with 1200+ lines of code, when it can be done with 4 lines....

Maybe someone else can help you make your sheet slower ;-)

[AdamDavidSzocs]

I couldn't agree with you more. The way I did it, is unreasonably complicated, making it open slow, save slow, work slow.

Let's just say I like the look of my checkboxes this way.

...and still would like to add a few, if there was a way.

Thanks for the help anyway, tried your solution, and it works good.