View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Tabstrip control

"Ric" wrote in message
...
How do I attach a control to the tabstrip in design mode? I would think I

could drag the control to the tabstrip and it would be owned by that
tabstrip. Does anyone have any suggestions?

Hi Ric,

I think you're confusing a TabStrip control with a MultiPage control. A
TabStrip control is not a container for other control like a MultiPage
control is.

A TabStrip is generally used when you have mostly identical layout for
all the tabs. The TabStrip control simply notifies you what tab is currently
active and your code treats the control accordingly. However, the controls
are exactly the same no matter what tab is selected.

A MultiPage control is used when you need a completely unique layout for
each tab. The pages on a MultiPage control are true containers, so when you
add a set of controls to one page, you will not see those controls when you
activate another page. All of them can be addressed directly from within the
UserForm, though, exactly as if they were placed directly on the form.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *