LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Userform assistance please

You could start a new workbook.

Then drag the userform from the original project to the new workbook project.

Rename the user form in the new workbook project--then drag it back.




Jim May wrote:

Thanks Tom;
Can I copy Userform1 and Paste as Userform1(Copy) and then modify the copy?
I don't see the option to do so. Can it be done, or done so by some other
equivalent?
Tks again.
Jim

"Tom Ogilvy" wrote:

If you make two userforms, you will have some common code which is
duplicated which would make maintenance repetative. It is possible to put
some of it in a general module and have it called by each form.

If you have only one form, then you have to write code to figure out who the
user is and adjust the form.

If the functionality of each form is quite different although the appearance
may be similar, then it might be better to go with two forms.

Those a two or three things I can think of and without deep thought, I don't
see any as being disqualifying. So the choice is really what you want to do
as I see it.

--
Regards,
Tom Ogilvy





"Jim May" wrote in message
...
I have a userform with multiple controls on it. It has 4 Command buttons
designed
to 1)save entered information, 2)retreive records, 3)print it, 4)delete
records.
All designed for the entry clerk.

I was the department director to use the same userform, except of course

they
should have a different set of command buttons; 1)To approve 2) to

transfer
record to Approved Folder, etc...

Question.. Do I use the same userform1 for both parties, hiding command
buttons of the other party or should I create another userform2 for them?

Am
I making sense; hopefully so?





--

Dave Peterson
 
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
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Assistance please? http:// Excel Worksheet Functions 7 July 6th 05 08:16 PM
Activating userform and filling it with data form row where userform is activate Marthijn Beusekom via OfficeKB.com[_2_] Excel Programming 3 May 6th 05 05:44 PM
Access from add_in userform to main template userform.... Ajit Excel Programming 1 November 18th 04 05:15 PM
Linking userform to userform in Excel 2003 missmelis01 Excel Programming 2 August 27th 04 08:07 PM


All times are GMT +1. The time now is 06:18 AM.

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"