Hide/Show Textboxes

[john55]

Hello guys,

I need to do some calculations, the values are added manually (here for testing I added some values in Sheet4) from printed papers, I tried to hide the unused textboxes (middle line -textboxes 12:20) but I think there are too many if(s) and I can not...
i.e
if I want to know the weight for temp= 34, wind=-10kt the textbox12 to be visible and the rest of them (textboxes 13:20) hidden.
or if I want to know the weight for temp= 34, wind=-5kt the textbox14 to be visible and the rest of them (textboxes 12....20) hidden.
or if I want to know the weight for temp= 34, wind=-7kt the textboxes12, 13, 14 to be visible and the rest of them (textboxes 15...20) hidden.
and so on
I appreciate your help!

[AndyLitch]

Not sure if this is exactly what you're looking for but it hides any textbox which has no text

Please Login or Register  to view this content.

[john55]

hi Andy
Thank you very much, but I it's not exactly what I'm looking for, since I need to type in it means all textboxes are empty, I need to hide those textboxes (from middle line) which are not related with my area of calculation.

[AndyLitch]

Can you maybe change the X values to suit ?

[john55]

I give up, I think it's complicated...I tried to do something for the "first part" of my userform, it works, but as you can see there are many combinations till the end and the code will be...let's say just "huge"! LoL
Thank you very much for your help!

Please Login or Register  to view this content.