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