Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dears,
I have a trouble in using if statement in macro, hope someone with "Excel"ent mind answer my question, sorry for my bad English. Here's the macro in my mind, If Userform1.Checkbox1.Value = True (If "AND" Userform1.Checkbox2.Value = True(If "AND" Userform1.Checkbox3.Value)) Then Run something I used this before, If Userform1.Checkbox1.Value = True And Userform1.Checkbox2.Value = True And Userform1.Checkbox3.Value = True Then Run something But when the Checkbox2.Value = False , It doesn't work , I changed AND to OR, same result, the point is when the value = False, then non-activate that condition. Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
if statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |