Hide button within userform if Combobox is blank

[jpruffle]

HI,

I have a ComboBox1 has populate other textbixes etc on a userform. The user then has the option to edit the existing data (CommandButton1) or Create new data (CommandButton2).

If there is nothing entered into ComboBox1 then I would like to hide CommandButton1 from my form. Is this possible?

I have tried some code but cannot get it working:

Please Login or Register  to view this content.

This hides the button but doesn't show it when text is entered into ComboBox1 (mename)

Thank you in advance

[jpruffle]

I managed to figure it out. I placed the same code in the userform initialize and on the combobox change event. That enabled it to work.