option button to cell

Hi all

I have attached a sample workbook because the original is too big.

I could use some help on this code since I don't really know any code, what I'm attempting to do is
when the form opens and they click the option button under the yes, that an amount of $30.00 will
show up in cell C1, and when they pick the option button under the NO, I can write in the amount
and that amount will show up in cell C1.

Thanks
Keith

Put this under the userform code

Please Login or Register  to view this content.

I want only add one thing. You van write:

Please Login or Register  to view this content.

Hi guys thanks for your response

is there a way that every time I open the form it fills strait down in column c?

I'm going to mark this solved and add rep to you guys next time I log on which will be in a few hours or sooner

Thanks
Keith

Yes, just write code into the UserForm Initialize procedure. You many want to specify start and end rows that fill down.

Thanks stnkynts

Only problem is I don't know how to code it , but if I did lol, I would make next entry in E1, skipping D1, then every other entry into,
G1, I1, K1, M1, O1, and so on, the reason is because the form I'm adding the code too, has 2 columns, for each entry. I attached what was done so far
if you feel like helping me out on this, I need the next entry to be entered into the yellow cells. the original program is too big to post.

Thanks
Keith

Do you mean like this?

Please Login or Register  to view this content.