userform for multiple sheets
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.
|