How to capture value from Check Boxes

[tushar@excel]

Hi All,

Let me state my requirement first -
In My excel sheet, if a user enters that database has been changed then i am throwing a form, which consist of 11 check boxes and each check box is mapped to a existing table.
To capture the value i am using the event, and populating a global variable.
Though this method is easy, but i don't like it.
Is there any other way by which i can pass information from my form to the program.

Regards,
Tushar

[royUK]

Your question doesn't give enough information. Which event are you using & what is supposed to happen?

[tushar@excel]

HI,

Whenever you put a check box onto a form , a check box event is created and when you click that checkbox, the event is triggered.
suppose -
ChkBox1 - has Table1 as name
ChkBox2 - Has Table2 as name

When you click chkbox1, the event CheckBox1_Click() is triggered.
To capture the vale i am doing the following -

Private Sub CheckBox1_Click()
TableChecked(2) = "TABLE1"
End Sub

TableChecked is a global array.

What i want is alternative of what i am doing above.
is there any other way by which i can know the values .


Regards,
Tushar

[Andy Pope]

You can check the state of the checkboxes via the userform object before you unload it. So you main routine may look like this,

Sub Main()

Userform1.Show

msgbox Userform1.Checkbox1.Value

Unload Userform1

End Sub

[royUK]

Tushar, please use Code tags when posting code.