LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to update data from multiple sheets to one specific sheets Khawajaanwar Excel Discussion (Misc queries) 4 January 15th 10 07:31 AM
Use 1 userform for many sheets, Rather than 1 userform per sheet: How? Corey Excel Programming 3 November 30th 06 06:44 AM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
Printout sheets with a userform fragher75[_9_] Excel Programming 5 April 8th 06 09:25 PM
userform that add data in all w/sheets tkraju via OfficeKB.com Excel Discussion (Misc queries) 0 March 24th 06 04:29 AM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"