VBA hidden textbox disappears when sheet copied

[cdgibson]

Hey everyone!

New to the forum, but have used it in the past to figure out some previous VBA issues -- so I figured I'd reach out to see if anyone can help me with my current issue.

Full disclosure: I'm not the most experienced at VBA, so any dumbed down explanations will be greatly appreciated!

General idea behind my code *not actual cell references, just an explanation*:

Cell A1 has a drop down for Case 1 or Case 2
For each case I have an image and two text boxes that I am making visible/hiding depending on if case 1 or case 2 is selected.

Case 1: Image 1, TextBox 2 and TextBox 3
Case 2: Image 2, TextBox 4, Textbox 5

Right now what I have works flawlessly in the current worksheet, however, when I want to make a copy of the worksheet...some of the text boxes that should be visible now will not reappear, or will show up when they are supposed to be hidden. So example: I select Case 1 and have Image 1, TextBox 2, and TextBox 3 showing -- I now copy this sheet and go to toggle to Case 2 -- however now I have Image 2, TextBox 4, TextBox 5, and either Textbox 2 or 3 now showing OR perhaps TextBox 4 or 5 will be missing.

I've attached the spreadsheet in question -- I think you will see what I am talking about once you copy the worksheet and look at the 3D labeled images.

I assume my code is not the prettiest (as I said, totally inexperienced with VBA) -- but if there is any fix that you can think of please feel free to share!

[skywriter]

Talking about a drop down in A1 when there isn't a drop down in A1 and telling us to just copy the sheet and we will see what you mean doesn't help us. You know your sheet and what you should be seeing, we don't.
Tell us specifically how to recreate the problem, what we will see and what we should see and we can probably work from there.

[cdgibson]

Like I said, the cell references were just used as a simple explanation, not true references... just to give a general idea of what I am doing with the sheet. Sorry for the confusion.


Anyways, to further clarify with actual references:
F10 - toggle to Yes
F11 - toggle to K25% 1
H179 - toggle to Case 2

When you look at the 3D image to the right, you will see a text box at the end of each arrow (a steel angle size should be showing here)

Now make a copy of the sheet. Change Cell F11 to say K33%, you will see two text boxes missing on the 3D image on the left side (TextBox 37 & 38) -- and one from the K25% floating in the upper right corner (TextBox 39).

Everything works as it should before I copy the sheet, it's only after I copy and then change F11 where I encounter the missing text boxes or text boxes appearing even though I have them set to hidden.

[skywriter]

Like I said, the cell references were just used as a simple explanation, not true references... just to give a general idea of what I am doing with the sheet. Sorry for the confusion.

Yeah, I get that.
Like I said, it doesn't help.
Good luck.