View Single Post
 
Old 07-11-2015, 08:01 PM
jaymudda jaymudda is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jul 2015
Location: london
Posts: 6
jaymudda is on a distinguished road
Smile Hide a combo box (form control), based on a cell value - Excel 2010

Hi guys

I'm TOTALLY new to this.

I am using Excel 2010

I have a worksheet called "Price Calculator", In it are 4 form control combo boxes:

1) "Drop Down 3", linked to cell $A$11
2) "Drop Down 11"
3) "Drop Down 12"
4) "Drop Down 13"

(I've got these combo box names from the section to the left of the formula bar when the respective combo box is right clicked)

What I'm trying to achieve is:

Whenever the cell link value to "Drop Down 3" <2 (i.e. when $A$11 <2) , I want the other 3 combo boxes to be automatically hidden
And whenever $A$11 >= 2, I want them to reappear

Could someone please help me with the VBA code? And where do I put this code exactly? (in case I've been doing that bit wrong)

I have tried everything I can find on the internet, but nothing seems to trigger a change event

Would really appreciate your help
Reply With Quote