HI friends!!

      I am creating runtime CheckBoxes at my Form. I have a Button also at my form and by clicking at this Button I have to Mark all the checkBoxes. I am using here For each loop and getting all the controls by this loop now I have to find that when control is CHECKBOX then i have to set its .Value property to 1.

      So please can anyone will tell me how can I get the control's type to get CheckBox from all the controls like Button, Textfileds etc.

DPK..

__________________
DPK..

Hi

The following should help you

Dim ctl As Control
Dim ctlCount As Integer


Dim iTab As Integer
For Each ctl In UserForm2.Controls
    If ctl.DisplayStyle = fmDisplayStyleCheckBox Then
        MsgBox "Control is CheckBok"
    End If


Next ctl

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

thanks shasur for your reply but i have done it with this..
:)

    dim ctrl as controls
    for each ctrl in me.controls
       if typeof ctrl is CheckBox then
           msgbox "this control is checkbox."
       end if
    next

thanks agian..take care!!!
DPK..