ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,235
- Office Version
- 2007
- Platform
- Windows
Hi,
In my CoboBox5 there are various options.
Two of them need to show N/A
Ive done the below which works fine BUT as opposed to making a duplicate how can i also have another paramater in the same line.
Basically i need N/A applied to a worksheet cell if HISS CABLE ONLY or CLONE ONLY was selected
So like this example
If Me.ComboBox5.Value = "HISS CABLE ONLY" or "CLONE ONLY" Then
Here is the code.
In my CoboBox5 there are various options.
Two of them need to show N/A
Ive done the below which works fine BUT as opposed to making a duplicate how can i also have another paramater in the same line.
Basically i need N/A applied to a worksheet cell if HISS CABLE ONLY or CLONE ONLY was selected
So like this example
If Me.ComboBox5.Value = "HISS CABLE ONLY" or "CLONE ONLY" Then
Here is the code.
Rich (BB code):
If Me.ComboBox5.Value = "HISS CABLE ONLY" Then
.Cells(8, 8).Value = "N/A"
End If