Conditional formulas
You can do that with an event sub, something like this: if Credit Card cells
are in column A, selecting this cells it'll unhide the next row otherwise it
hides the next row.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 Then 'column A
If Target.Value = "Credit Card" Then
Rows(Target.Row + 1).EntireRow.Hidden = False
Else
Rows(Target.Row + 1).EntireRow.Hidden = True
End If
End If
End Sub
Post if you need help to install it!
Regards,
Stefi
SLW ezt *rta:
HELP! is this possible?.. I need a formula, so if a cell shows "Credit Card"
then a row appears with areas for the credit card details, but if the cell
doesn't show "Credit Card" then the row stays hidden. Not sure if this makes
sense, what I want is a row to appear where the user can input their credit
card number, name etc. but the row to stay hidden if the paying by an
alternative method..
|