user form to run macros to populate data in sheet..

[alwaysneedhelp]

hey all,

have a Sheet that a fill data constantly into everyday all day..

i created a user form

and this is the layout i want.. and i have created a macro for each check box...

when i click on any one of the check boxes i want to click ok, and have the corresponding macro run in the sheet.

i have attached the form. the sheet and a sample macro... if someone can write me the one line of code for this to happen i can just simply replicate the other 39 my self.
i have attached the macro and would like it to correspond with the check box.

any help MUCH appreciated.

book12.xlsm

[alansidman]

Inserted a button on your spreadsheet to open user form. Linked OK button to your macro. See attached.

[alwaysneedhelp]

i tried to write a reply did not go through... least its not showing up hope this is not a re-do.

worked great, guess I am worse at excel than i thought, thought would be an easy string to replicate..

but the code string does not mention the checkbox or anything just links right to command button so how do i go about adding seperate checkboxes to the code for different macros if that one checkbox is linked directly to the button..

i was expecting something alone the lines of calling macrocs if check boxes were true etc. I guess just wondering how to add a separate checkbox with aseperate macro

thanks again

[alwaysneedhelp]

i tried to write a reply did not go through... least its not showing up hope this is not a re-do.

worked great, guess I am worse at excel than i thought, thought would be an easy string to replicate..

but the code string does not mention the checkbox or anything just links right to command button so how do i go about adding seperate checkboxes to the code for different macros if that one checkbox is linked directly to the button..

i was expecting something alone the lines of calling macrocs if check boxes were true etc. I guess just wondering how to add a separate checkbox with aseperate macro

thanks again

[alansidman]

Let me make sure I understand.

You will have multiple checkboxes. If one is checked then you wish to run specific code for that checkbox? What if more than one checkbox is checked? what should happen? I am thinking that instead of checkboxes you probably want to have radio buttons so that you can only check one at a time.

Then I would suggest that based upon the radio button, you have a Select Case statement and list the macros to run for each radio button when the OK button is selected. I apologize if I did not understand your initial request correctly.

Alan

[alwaysneedhelp]

yes exactly,

i plan on having 40 checkbxes or radio buttons, each assigned to seperate macros which fill data into that sheet.

select, click ok watch it fill!

you nailed it.

[alansidman]

Suggest you build your form with radio buttons and then post it, then we can work on creating a Select Case statement for at least two situations and then based upon that, you can create the remaining 35+ scenarios.

Because I don't really understand what you want your Macro(s) to do, I am wondering if there might be an easier way than building 40 macro statements. If you would take the time to write out what you want your macro(s) to do, we might be able to offer up a better solution. Try to be clear and concise. Use the spreadsheet you have posted as your example.

[alwaysneedhelp]

deal,

will post tomorrow am

[alwaysneedhelp]

here it is,

form is attached, when click megger button,

want each radio button assigned to each macro with same name... all are in there if someone can get me started ill handle the rest!

thanks all

111.xlsm

[alansidman]

I started to work on this, but noted that after the first 10 option buttons, the names of the buttons do not correspond to their label. It would be easier to create code if the button names corresponded to their label and the macro to be called. As a developer, this will make is easier to debug any code you have should the need arise. Once that has taken place then you can use code similar to the following:

Please Login or Register  to view this content.

[alwaysneedhelp]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

im retarded?

[alwaysneedhelp]

nothing happens cant even click on

[alwaysneedhelp]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

tried this also..

complie error unexpected varible.. highlights call FOUR

[alansidman]

Not sure why you are getting a compile error. Look at this tutorial as it explains exactly (I believe) what you are trying to do.

http://www.homeandlearn.org/excel_vba_subroutines.html

By the way. Please read our rules about code tags. I fixed them for you this time, but in the future you will need to add them yourself or you may feel the wrath of a less amicable moderator.

Alan

[alwaysneedhelp]

sorry guys forgot my computer at work and phone and everything else electronic,

gave up nothing worked so just running the macros from macro menu without the form, works fine just slower all good