Conditional Hiding?

[StriderUCR95]

I have a pricing sheet that i would like to conditionally format. I have a drop-box list, and i want to format so that a hidden row appears (that i hid there before) if a specific value is entered. Is this even possible, and if not, does anyone have any recommendations for something similar to this? Basically where i work i have set product sizes, but sometimes we deal with custom sizes. I want a hidden row (with dimensions and such) to pop up if i select "other" in the drop-box list of dimensions. Thanks in advance.

 

[Makrini]

Are you using Data Validation for your drop box? Or a Combo Box?

If using a Combo Box - set a Macro to unhide if the value = "Other"

 

[HalfAce]

Hello StriderUCR95, welcome to the board.
Sure, this is very possible.
Just how much is involved depends on what you mean by "drop-box"

If you're looking for suggestions, I'd look at using a data validation cell as my first choice
(for the mechanics of what you want to do, not necessarily the appearance.) If you
want to use a ComboBox instead I suggest the one from the Controls Toolbox toolbar
as opposed to the Forms toolbar.
Let us know which you're going to choose for the quickest (meaningful) response.

 

[StriderUCR95]

I am using Data Validation for my drop box. However, if there is a better alternative for my application, then feel free to let me in on it.

 

[StriderUCR95]

Bumpity bump.

 

[HalfAce]

OK, for a data validation cell...
Assume your validation cell is cell A1, and the row to hide/unhide is row 20.
Right click the sheet tab for the sheet of interest and choose View code.
Copy & paste this into the sheet code module. (The white area on the right.)

Private Sub Worksheet_Change(ByVal Target As Range)
Rows(20).Hidden = Not [A1].Value = "Other"
End Sub

Press Alt+Q to close the vb editor and try it out.

Hope it helps.