Userform assistance please

[Jim May]

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?

 

[Tom Ogilvy]

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.

 

[Jim May]

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]

I believe you export it and then import it again.

Once you export it, use Notepad to edit the .frm file Change references
from Userform1 (for example) to Userform2, or something similar. Save the
file.
Then import the form.

 

[Jim May]

Thanks Tom,
I'll give it a go.
Jim

I believe you export it and then import it again.

Once you export it, use Notepad to edit the .frm file Change references
from Userform1 (for example) to Userform2, or something similar. Save the
file.
Then import the form.

 

[Dave Peterson]

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.