Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding tabstrip and runtime
I have the following code that adds a TabStrip and tabs at runtime. This is
the basic form, since the number of tabs will be determined by data on a worksheet. What I'm having trouble with is how to refer to the tabs later in the code. In my example, I end up with TabStrip1 with 11 tabs (.Value=0-10) named Tab1 through Tab11. Private Sub UserForm_Initialize() Set MyCtrl = UserForm1.Controls.Add("Forms.TabStrip.1", "TabStrip1") For x = 2 To 10 Set MyNewTab = MyCtrl.Add("Tab" & x + 1, "Tab" & x + 1, x) Next x End Sub When I try to refer to the TabStrip or the tabs, I get an Object Required error. What would be the proper way to refer to these items after created at runtime? TIA -- Michael J. Malinsky |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue Adding an Array Formula to a cell at Runtime. | Excel Discussion (Misc queries) | |||
tabstrip when chart is saved as webpgae | Excel Discussion (Misc queries) | |||
Strange problem with a dynamically populated tabstrip on a worksheet | Excel Programming | |||
DataCombo seems locked after changing TabStrip | Excel Programming | |||
DataCombo seems locked after changing TabStrip | Excel Programming |