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.

userform for multiple sheets
 

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.

userform for multiple sheets
 

Maybe yu should have one form with two buttons. Then move the data from the
form to the correct spreadsheet . Lock both worksheets so user can't write
into the wrong sheet.

There are event functtions which can be uised when a workbook is open and
before it is closed that may help your problem.

You can add a button to your worksheett by going to the spreadsheet and
slecting View - Toolbars - Control Toolbox. then adding a command button.
Pressing the command buttton will automatical run a macro that you can write.

"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.

userform for multiple sheets
 

Yes. you could remove the multipage and add two option buttons, or put up a
message box with the question when they hit the button to save.


--
Regards,
Tom Ogilvy


"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.

userform for multiple sheets
 

Thank you all for your help!

"JW" wrote:

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.