View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matty Dread Matty Dread is offline
external usenet poster
 
Posts: 1
Default Looking for an easier way to change the name of copied controls...

I have a multipage userform which, once completed, will have 5 pages. The
form is being used to calculate multiple quotes, so each individual page will
be identical in structure and function, but give the user the power to change
certain criteria pertinent to that quote. (As if you really needed to know
all that...)

My problem is this: I set up the first page which has several text/combo
boxes in frames and there is a lot of code behind them. My plan (unless
there is someone out there that can help me) is to copy all of the controls
and paste them on the other sheets. What I am not looking forward to (and
perhaps there is no solution and I'm just being lazey) is renaming all of the
controls on the 4 other pages.

So, finally, my question:

Is there a way to change the name of my textboxes & comboboxes with VBA?
I'm pretty new to this and as much as I've learned in the past few months, I
just can't seem to figure this one out. Any help would be GREATLY
appreciated!

Regards,
Matty