Hi,
I'm trying to develop a word form that records details of an organisation. One question is 'What type of organisation are you?'
The options are;
Communtiy
Voluntary
etc etc - for each org type I have a checkbox. I want the checkbox's to all have different values, so if Community was checked it would = 1, voluntary = 2.
The reason for this is that I'm transferring the data from the form into excel to further put into a mysql DB.
Many thanks for any help!
PS Is there a way to add this macro into forms that already have data!
My initial research has found this;
Quote:
Private Sub Checkbox1_Click()
> If Sheet1.CheckBox1.Value Then
> 'Do Stuff
> Else
> 'Undo Stuff
> End If
> End Sub
|
Would like to have 1 macro though not one for each checkbox.