Thread: Hide a combo box (form control), based on a cell value - Excel 2010
View Single Post
 
Old 07-12-2015, 06:04 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Yes, that's what I said. The only change would be If Range("C1") < 2 Then
The drop downs stay qualified as they are.

Must admit though, I haven't tested it this way.
Let me know if that works for you.
Reply With Quote