How to make textbox visible true/false

Hi Again All.

I have written this code to make 2 textboxes appear/disappear on my userform. I've obviously done it wrong as the visibility bit works but not the part where I want the textboxes to disappear. Basically I want them to disappear if anything other than "Honeycombs" is in the ComboBox.

Please Login or Register  to view this content.

It's probably staring me in the face but I just can't see it. Thanks, as usual, for any help. All the best

Try this,

Please Login or Register  to view this content.

I would use a simpler construct of:

Please Login or Register  to view this content.

The toggles the visibility automatically based on whether the ( ) test is true. if true, they are visible, if not, they are not visible.

@fremarco,

I like Jerry's answer but just to add to it I would go one step further using Ucase. So weather user types in Ex: HoneyCOmbs or honeycombs or any variation of the word it will work

Please Login or Register  to view this content.

Sleep is for people who use pen and paper.