Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Checkbox checked/notchecked then
Hello,
I've never worked with checkboxes in a userform before, and am I little unsure as to how to use them. What I have is a userform where the users input their data in textboxes, then there is a checkbox that they might or not might check. Now depending on whether they check it, using If statements probably I need certain actions done, it is probably similar to this: If CheckBox1.Checked Then ...... But that does not work? Any ideas, to point me in the right direction? Thanks. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Checkbox checked/notchecked then
If checkbox1.Value = True then
or if checkbox1.Value then -- Regards, Tom Ogilvy "Darrin Henry" wrote in message ... Hello, I've never worked with checkboxes in a userform before, and am I little unsure as to how to use them. What I have is a userform where the users input their data in textboxes, then there is a checkbox that they might or not might check. Now depending on whether they check it, using If statements probably I need certain actions done, it is probably similar to this: If CheckBox1.Checked Then ...... But that does not work? Any ideas, to point me in the right direction? Thanks. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Checkbox checked/notchecked then
Oy, I knew this was incredibly simple. Thanks Tom.
*** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox checked then show more checkboxes | New Users to Excel | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
How do I give a checked checkbox a value in excel(as .5)? | Excel Worksheet Functions | |||
Is checkbox is checked? | Excel Discussion (Misc queries) | |||
checkbox - default checked or un-checked | Excel Programming |