UserForm-New one or Reuse Original?

J

Jim May

I'm putting together a small application (AppPOEntry.xls) and need some
assistance. An entry form (frmEntry) I've built has several controls
(optionbuttoms, frames, text boxes, etc) with tailored command buttons <<<
for the entry clerk..

If in the same app (file AppPOEntry.xls) I wanted the Dept Director to
access the Form and have a different set of command buttons (other than
entry-type to update, ect) before sending-on (etc), in prog-developement
would I refer to the same userform (frmEntry) and hide (property) the entry
persons command buttons and add a new set for the Director?..
Or, Copy the frmEntry and paste (renaming) frmApproval (a sencond form)? Is
so, how do I copy frmEntry and rename the copy frmApproval?

Or should the Dept Director have his own separate app (AppApprovals.xls)?
Still, I'd like to show the
same frm (content and look) with the first mentioned contols(optionbuttons,
frames textboxes, etc) but with a different set of command buttons << for
the Department Director to Click on in his approcal process...

Can someone give me some guidance?
TIA,
Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top