Hide/Unhide Combo box via command button

**staples** · 10-20-2009, 05:15 AM

Hi there

I am wondering if there is a way to hide a combo when excel is opened then unhide it when a user clicks on a command button. I have searched around for this problem however was unable to find a full answer which worked for me.

I have attached my sheet below if this helps. I would like to hide the combobox below the Seach Product button, then show the combo box as soon as the user clicks "Search By Product2

Any help would be great
Thanks

**Richard Buttrey** · 10-20-2009, 06:01 AM

Hi,

Use an Activex ComboBox rather than a Forms ComboBox.

Then in the WorkbookOpen event add the line:

Please Login or Register  to view this content.

and create a macro attached to the click event of the Search by Product Button

Please Login or Register  to view this content.

HTH

**MickG** · 10-20-2009, 06:15 AM

Hi, Try this:- Your Command Button and Active sheet event .
Regards Mick

Hide/Unhide Combo box via command button

LinkBack

Thread Tools

Rate This Thread

Display

Hide/Unhide Combo box via command button

Re: Hide/Unhide Combo box via command button

Re: Hide/Unhide Combo box via command button

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions