Create a macro & assign to a button

[MAMC84]

Hi all -

I'm back for more unparalleled advice.

I have a column where the answer choices are either Yes or No (which are in a drop down). I'd like to find a macro that I can assign to a button for the user to say "YES" to all. Then I'd like to find a macro that can be assigned to a button for the user to "CLEAR" the results. All of this in column J, and between rows 12 to 359.

Can someone help me with the macros? Once the macros are created, I think I know how to assign it to a button.

Cheers!

[Ceeseven]

sub clear()

Range("j12:j359").Select
Selection.ClearContents
Range("j12").Select

end sub

Please Login or Register  to view this content.

[Ceeseven]

oops sorry thought i had this in there

Please Login or Register  to view this content.

btw... this kinda of stuff i learned from doing 'record'
so that means ther could be an easier way =)

[MAMC84]

Thanks Ceeseven!