I have a userform that automatically opens by running another macro. I need it to allow a user to select a method. The form has 3 OptionButtons, True, False and NA. Based on which OptionButton the user selects, a value is placed in several cells. So if the radio button next to True is selected, then the number 100 is placed in cells C10, C20, C30, C40 and C50 when a command button is clicked. If the False radio button is selected, then the number 50 is placed in those same cells and if NA is selected then "NA" is placed in cells C10, 20, 30, 40 & 50. I have the userform built, but I can't seem to get it to do what I need it to. Any help would be greatly appreciated. Attachment 134376
Bookmarks