Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Select All" checkbox (or any other form tool)
Hello,
I need to be able to check off one box and have an entire section of boxes be checked off with it )like on a website form). What's the best way to go about doing this? Can a function be used, or does it have to be a macro? I'm not a great excel programmer, so, please, be gentle... Thanks very much, Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Select All" checkbox (or any other form tool)
That can only be done with a macro. There are two types of check boxes that
you might have. One comes off the forms toolbar and the other comes off the Control Toolbox. They are different. My preference would be to use the ones off of the Control Toolbox for this but either one will work. -- HTH... Jim Thomlinson " wrote: Hello, I need to be able to check off one box and have an entire section of boxes be checked off with it )like on a website form). What's the best way to go about doing this? Can a function be used, or does it have to be a macro? I'm not a great excel programmer, so, please, be gentle... Thanks very much, Bill |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Select All" checkbox (or any other form tool)
Ok, thanks. Now how would I do that? Sorry, I'm new to this.
Bill |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Select All" checkbox (or any other form tool)
Sorry about being gone so long... Christmas Lunch. I just can't pass up free
food. Try this. Check boxes are from the control toolbox. My assumption is that the first box added is the one you want to be the select all. Private Sub CheckBox1_Click() Dim cbx As OLEObject Dim wks As Worksheet Set wks = Sheets("Sheet1") For Each cbx In wks.OLEObjects If cbx.OLEType = 2 Then If CheckBox1.Value = True Then cbx.Object.Value = True Else cbx.Object.Value = False End If End If Next cbx End Sub -- HTH... Jim Thomlinson " wrote: Ok, thanks. Now how would I do that? Sorry, I'm new to this. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to do if I would like to select from a list by using "IF" form | Excel Worksheet Functions | |||
any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |