conditional formatting a Combo Box
 

Is it possible to format a combo box so that it is inactive (grey'd out)
unless a certain criteria is met?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

conditional formatting a Combo Box
 

ComboBox1.Enabled = (YourCriteria = True)

NickHK

"blackbox via OfficeKB.com" <u20390@uwe wrote in message
news:736105a8095af@uwe...
Is it possible to format a combo box so that it is inactive (grey'd out)
unless a certain criteria is met?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

conditional formatting a Combo Box
 

Hi Nick
where do I put that?

Thanks

NickHK wrote:
ComboBox1.Enabled = (YourCriteria = True)

NickHK

Is it possible to format a combo box so that it is inactive (grey'd out)
unless a certain criteria is met?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1