I would place a frame at the top of the form with the two option
buttons in it. However, if you do not clear the user's selection
after every entry into the sheet, you could still run into the
situation where the user enters the info in the wrong sheet. You
would need to clear the selection after each entry and put a check in
there to make sure the user made a selection.

Joe Lee wrote:
Hi. newb here.
I have created a userform to add new entries into two different sheets, but
with the exact same type of information (dept, status, project name, etc).
Depending on what type of project it is determines which sheet it goes to.

I currently have a tabbed userform where the user would click on the tab to
send the information where it needs to go. But users tend to forget, complete
the form and either enter it onto the wrong sheet or click on the other tab
and start over. Both pages look exactly the same.

I was wondering if I could use something like an option button asking the
user which of the two sheets the information will be entered into, sort of
like a trigger. I just think the two tabs with the two pages looking exactly
the same just looks weird and dumb.

help please.