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;

Would like to have 1 macro though not one for each checkbox.

Why don't you use a dropdown?

PS: As your question relates to Excel, I'm moving this thread to the Excel programming area.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]