Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Assistance please? | Excel Worksheet Functions | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |