VBA userform Textbox visible = true

[Hilton1982]

Hi

I have a cbox that has for numbers 601,602,603,604 and on the exit event a textbox will display the text that matches the number with a Vlookup formula.

That all works fine...

Now i have added another textbox which is not visble and should only be visible = true if the code in the cbox is 601.

Below is the code i have however even if i select 601 the txtbox does not become visible. there must be a problem with my wording?

Please Login or Register  to view this content.

Please help???

[haripopuri]

Try putting textbox visible code in cbox change event.

[JosephP]

your And part is incorrect-it's actually just doing a bit wise comparison

Please Login or Register  to view this content.