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


    Rob


    Why do you need the checkboxes?


    Wouldn't it be a better idea to have a listbox (or two)?


    One could have the user options eg IT User, Research User etc, the other all the options.


    This setup would be far easier to deal with than multiple checkboxes, and a listbox can actually be formatted to display checkboxes if required.


    As to the New Mobile User/Blackberry checkbox, why not use a command button instead?

  • 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 Norie. Boo yourself!!


    You can't tell what application anyone is using by the Forum because so many people post to the wrong Forum

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


    Roy


    My problem is that I just hit New Posts, see if the thread title interesting, click the link and then a few hours later realise what the actual forum was.:)

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!