View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default Count CheckBoxes in a Frame that are True

The easy way is:
if checkbox1=true then
if checkbox2=true then
if checkbox3=true then
if checkbox4=true then
combobox1.Enabled=False
end if
end if
end if
end if
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"RyanH" wrote:

I want to disable a ComboBox if all 4 CheckBox Values in a UserForm Frame are
True. How do I do this?

Ryan