Hi guys,

Two specific combo boxes, cmbhardwarecat and cmbprintercat.
If cmbhardwarecat = printer then show cmbprintercat (including lable:
lblprintercat) otherwise hide.

trying to work out why this isn't working:


Code:
--------------------
Private Sub cmbprintercat_Change()
If Not cmbHardwarecat.Value = "Printer" Then
cmbprintercat.Visible = False
lblprintercat.Visible = False

Else

If cmbHardwarecat.Value = "Printer" Then
cmbprintercat.Visible = True
lblprintercat.Visible = True

End If
End If
End Sub

--------------------


Any ideas would be much apprciated.


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=541063