How to code an overwrite or append via radio button

[dovermac]

Hello!
I have a small userform I designed. The top is a combobox which will have 10 csv files to pick from. The bottom is an open command button which allow the user to open any file anywhere. Lastly, is a radio button that says overwrite. Since I'm new to vba, I need to code the ok button so that if the radio button is ticked (on) it will take the file contents in the Open field and replace whatever is in the combobox file. If it's not ticked (off), it will append instead. I haven't the slightest how to code this except as an if-then scenario. I've been looking for some specific examples, but so far no luck. Any advice for this novice?

Thanks,
Jeff

[LJMetzger]

Hi dovermac,

See the attached sample file, which will probably point you in the right direction. I added a second OptionButton, so you select either 'OverWrite' or 'Append', which is how I would do it if it were my project.

Please ask if you don't understand, or have any more problems or questions.

Lewis

[dovermac]

Thanks Lewis!!!