View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default UserForm-New one or Reuse Original?

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