Solved

VBA: how to reset checkboxes inside a frame

Posted on 2009-07-01
3
548 Views
Last Modified: 2013-11-26
Hi x-perts,

is there a way to reset ALL checkboxes inside of a frame?

Thanks
0
Comment
Question by:andy7789
  • 2
3 Comments
 
LVL 65

Accepted Solution

by:
RobSampson earned 500 total points
ID: 24775269
Hi there,

I haven't tested these options, but you can either of the two below.

Regards,

Rob.
' Option 1

    Dim ckBox As OLEObject

    For Each ckBox In MyForm.MyFrame.OLEObjects

        If TypeName(ckBox) ="CheckBox" Then ckBox.Object.Value = 0

    Next ckBox
 

'Option 2

For Each objControl In MyForm.MyFrame.Controls 

    If TypeName(objControl) ="CheckBox" Then 

        ckBox.Object.Value = 0

    End If 

Next ctl 

Open in new window

0
 

Author Comment

by:andy7789
ID: 24778228
Thanks, Rob,

none of your versions worked, but this is a slightly modified one that makes its job:

Cheers,

Andy
For Each objControl In Me.Frame2.Controls

    If TypeName(objControl) = "CheckBox" Then

       objControl.Value = 0

   End If

Next objControl

Open in new window

0
 
LVL 65

Expert Comment

by:RobSampson
ID: 24778502
Oh yeah, typo in my option 2....sorry about that.

Thanks for the grade.

Regards,

Rob.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now