Vba Macro To Have A Checkbox That Ticks A Number Of Checkboxes On The Form

Hi guys

I'm trying to build a "New user form" that automates the process of new users joining the company.

What I have done so far

1) Created a Macro that launches a form that has a number of fields where you enter "First Name, surname etc. etc. etc." you then input the values and it propagates a template below with the relevant information.

2) The template has alot of checkboxes I have created for the different Applications we use, I would like to add a checkbox on the Macro Form for I.e. "IT User, Research User, Developer, etc. etc.

What I would like to know is how do I script that when the form is checked with say "IT User" it ticks a number of the checkboxes on the UserForm pertaining to the various IT related products, if they tick "Research User" it must tick the relevant checkboxes on that side.

On a side note, is it possible once opening this form and selecting the checkbox "New Mobile User/ Blackberry" along with all the other information entered it.

1) propagates the relevant template with the information.
2) opens the New Blackberry mobile form (another form that can't be added to the new user form) propagates that form with the relevant information as well (name etc. etc.) as to not duplicate work.

Thanks for any assistance.

Rob

Re: Vba Macro To With A Checkbox That Ticks A Number Of Checkboxes On The Form

Hi Norie

Thanks for the response. Unfortunately i'm more technical than development based, i've just been tasked with Automating this new user form as nobody else has had any experience with Macros.

I also have to design the New User form exactly the way it currently is. I.e. it's in PDF format where people print it out and fill it in manually ticking a number of checkboxes on the form for the relevant applications the user needs.

Thus i'm open to the suggestions I just don't really know how to implement them :p

I.e. the form has the checkboxes needed as per the PDF that gets printed. The checkboxes can be ticked or unticked manually but I want to make it automated so that when you select the radio button/ checkbox/ checklist etc. is propagates the form with ticks in the relevant checkboxes.

Re: Vba Macro To With A Checkbox That Ticks A Number Of Checkboxes On The Form

Hi Guys

Thanks for the replies, as far as I remember I posted in the Word help section..... Looking to do this within word only.

Thanks
Rob

Re: Vba Macro To With A Checkbox That Ticks A Number Of Checkboxes On The Form

Norie, that Excel AddUser may just help

Going to look at using that to propogate a Excel sheet and then use mailmerge to propogate the Word Document....

hmmm just thinking, it would be better to do this entirely in word.

Re: Vba Macro To Have A Checkbox That Ticks A Number Of Checkboxes On The Form

Hi Guys

I've moved the NewUser code into Word, one question: How do I change the specific options to display something else I.e at the moment they are option 1-->10 how do I make option 1 say Office 2003, Option 2 say Intranet option 3 say 3G etc.

Your assistance is greatly appreciated

Thanks
Rob