View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
harpscardiff[_30_] harpscardiff[_30_] is offline
external usenet poster
 
Posts: 1
Default Hide combo 3 based on combo1


I've cracked it - simple mistake!!

Used:

Code:
--------------------

Private Sub cmbprintercat_Change()
dim bolHardwarecatVisible as boolean
bolHardwarecatVisible = ucase(cmbHardwarecat.Value) =
ucase("Printer")
cmbprintercat.Visible = bolHardwarecatVisible
lblprintercat.Visible = bolHardwarecatVisible
End Sub

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


But applied it to the cmbHardwarecat - so:


Code:
--------------------

Private Sub cmbHardwarecat_Change()
dim bolHardwarecatVisible as boolean
bolHardwarecatVisible = ucase(cmbHardwarecat.Value) =
ucase("Printer")
cmbprintercat.Visible = bolHardwarecatVisible
lblprintercat.Visible = bolHardwarecatVisible
End Sub

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


cheers guys!!


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