Dynamic TextBoxN_KeyDown

[bongo_bg]

Hello fellow Excelers,

I have this weird issue that is pretty cosmetic but it's bugging me like hell and I want to fix it but I simply cannot think it through...

I have 3 TextBox ActiveX components and I have the following Subs:

Please Login or Register  to view this content.

The thing is that these 3 boxes are not always 3. Depending on other sheet values sometimes I have 2 and sometimes 1. Executed by both .Enabled = False and .Visible = False. Also as they are on 3 different rows I have .EntireRow.Hidden = True.

The problem is when I have 1 or 2 the KeyDown subs are unhiding the rows. I tried with multiple IFs and reinforcing the 'hiding' again but whatever I try the hidden rows always end up unhidden.

Any suggestion how I can optimize this?

Thank you!

[AlphaFrog]

Where is your code that hides\unhides rows?

[bongo_bg]

Public Sub in Module 1 'Call'ed in different ocasions. It's pretty long sub with a lot of IFs to paste it all but 1 of the fragments is:

Please Login or Register  to view this content.

If I try something like "if TextBox4.Enabled = False then".... 'skip tb4 and go to tb5' then I believe the checking of the 'if' argument is unhiding the row although the activating itself goes directly to tb5. It sounds weird but I believe it also makes sense.