Formula's not working Properly, and acting completely bizarre!

Hello all,

I've got a very very strange situation that I will try to describe as best I can, and unfortunately I can't post my workbook because it is to large.

A bit of background knowledge, Ive got two sheets working together: sheet 1 has some activeX boxes that when clicked, return a value in column Z on sheet 1 (activeX box #1 returns a 1 in Z1 when clicked, and a 0 when unclicked. Activebox #2 returns a value to Z2, and so un until Z9, which is my last cell that does this). I'm going to link a TON of code, and usually I would only link enough to get my point and purpose across, but in this specific situation I feel the entire code must be present.

Please Login or Register  to view this content.

I'm using the code below to run the above code anytime sheet #2 is activated.

Please Login or Register  to view this content.

So, now to my actual issue. When I click Box 1 (activeX box 1, ill just refer to them as "box") on sheet 1, it returns a 1 to Z1, and when I change to sheet 2, it works perfectly. When I do the same with Box 2, it also works perfectly. When I do the same with Box 3, it also works perfectly.

When I click Box 4, however, it returns a 1 to Z4, but it runs the code for Z6, listed below.

HTML Code: 

Box 5 has the same issue, and both Box 5 and Box 4 I've managed to solve by switching their perspective codes (If Z4 is supposed to show Rows 500-550 and Z5 is supposed to show rows 551-600, and Z4 is showing 551-600 while Z5 is showing 500-550, even though the code says it should do otherwise, I switched the code so If Z5 = 1, show row 500-550, and it does so even though Z5 has no value, and Z4 has the 1. Rereading this, I probably didnt make that clear, but I'm on a tight time frame so I will elaborate on that Tuesday morning.)

I'm out of room, so I'm going to post another comment after to continue.

Sky188,

Try changing the sheet2 worksheet_activate event to the following code:

Please Login or Register  to view this content.

And then remove the HIDEROWUSINGTEXT macro. Also make certain your "boxes" are changing the proper cells on the proper sheet. The worksheet activate event looks at cells on sheet2. If the boxes are changing cells in sheet1, the wrong rows will get hidden.

Sky188,

Originally Posted by tigeravatar

make certain your "boxes" are changing the proper cells on the proper sheet. The worksheet activate event looks at cells on sheet2. If the boxes are changing cells in sheet1, the wrong rows will get hidden.

Your checkboxes are changing cell values in the 'Questionairr' sheet, not the 'Products' sheet. The worksheet_activate event is on the 'Products' sheet so it can't see the cell values in other sheets unless explicitly told, like so:

Please Login or Register  to view this content.