Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
Use 1 userform for many sheets, Rather than 1 userform per sheet: How? | Excel Programming | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Printout sheets with a userform | Excel Programming | |||
userform that add data in all w/sheets | Excel Discussion (Misc queries) |