Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Checkboxes in Excel - Please Help!
I have several checkboxes in a form that I need to have the "True" or "False"
be filled in the database for this form. How do I do this? |
#2
|
|||
|
|||
Checkboxes in Excel - Please Help!
Hi TotallyConfused
I don't think i understand you but with code you can change the checkboxes like this Sub test1() 'control toolbox controls For Each obj In ActiveSheet.OLEObjects If TypeOf obj.Object Is MSForms.CheckBox Then obj.Object.Value = False End If Next End Sub Sub test2() 'forms controls ActiveSheet.CheckBoxes.Value = False End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "TotallyConfused" wrote in message ... I have several checkboxes in a form that I need to have the "True" or "False" be filled in the database for this form. How do I do this? |
#3
|
|||
|
|||
Checkboxes in Excel - Please Help!
Ron thanks for responding. I am not having problems with checking or
unchecking the checkboxes in my form. What I need is to have the outcome of the checkbox which would be a check or uncheck to export to the database linked to this form. So when I save my form and create a new record a True or False will be populated in the corresponding columns in the database. Or is there another way to do this? "Ron de Bruin" wrote: Hi TotallyConfused I don't think i understand you but with code you can change the checkboxes like this Sub test1() 'control toolbox controls For Each obj In ActiveSheet.OLEObjects If TypeOf obj.Object Is MSForms.CheckBox Then obj.Object.Value = False End If Next End Sub Sub test2() 'forms controls ActiveSheet.CheckBoxes.Value = False End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "TotallyConfused" wrote in message ... I have several checkboxes in a form that I need to have the "True" or "False" be filled in the database for this form. How do I do this? |
#4
|
|||
|
|||
Checkboxes in Excel - Please Help!
If you use a checkbox from the controltoolbox you can use
linkedcell in the properties. Copy this cell also to your database then -- Regards Ron de Bruin http://www.rondebruin.nl "TotallyConfused" wrote in message ... Ron thanks for responding. I am not having problems with checking or unchecking the checkboxes in my form. What I need is to have the outcome of the checkbox which would be a check or uncheck to export to the database linked to this form. So when I save my form and create a new record a True or False will be populated in the corresponding columns in the database. Or is there another way to do this? "Ron de Bruin" wrote: Hi TotallyConfused I don't think i understand you but with code you can change the checkboxes like this Sub test1() 'control toolbox controls For Each obj In ActiveSheet.OLEObjects If TypeOf obj.Object Is MSForms.CheckBox Then obj.Object.Value = False End If Next End Sub Sub test2() 'forms controls ActiveSheet.CheckBoxes.Value = False End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "TotallyConfused" wrote in message ... I have several checkboxes in a form that I need to have the "True" or "False" be filled in the database for this form. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |