Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tabstrip tabs entered programmatically disappear after form unload
Hi,
I can enter tabs into a tabstrip programmatically with no problem, but when I open the form after closing it, the added tabs are not there. I'm using XP SP2 and Excel 2003. Code as follows: Sub AddTabs() Dim TestStrip As TabStrip Dim TabCounter As Integer Dim TestTab As Object TabCounter = 0 Do While Worksheets("Stocks").Cells(21 + TabCounter, 11).Value < "" Set TestStrip = Form1.TabStrip1 Set TestTab = TestStrip.Tabs.Add("MyTab" & TabCounter + 1, "MyTab" & TabCounter + 1, TabCounter) TabCounter = TabCounter + 1 Loop End Sub Thanks in advance! Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tabstrip tabs entered programmatically disappear after form unload
Examine this code example and see how John uses the designer property:
http://j-walk.com/ss/excel/tips/tip76.htm -- Regards, Tom Ogilvy "cumchee" wrote in message ... Hi, I can enter tabs into a tabstrip programmatically with no problem, but when I open the form after closing it, the added tabs are not there. I'm using XP SP2 and Excel 2003. Code as follows: Sub AddTabs() Dim TestStrip As TabStrip Dim TabCounter As Integer Dim TestTab As Object TabCounter = 0 Do While Worksheets("Stocks").Cells(21 + TabCounter, 11).Value < "" Set TestStrip = Form1.TabStrip1 Set TestTab = TestStrip.Tabs.Add("MyTab" & TabCounter + 1, "MyTab" & TabCounter + 1, TabCounter) TabCounter = TabCounter + 1 Loop End Sub Thanks in advance! Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to unload a form in excel vba? | Excel Programming | |||
Unload the form on esc key | Excel Programming | |||
Load and Unload Form commands | Excel Programming | |||
form won't unload | Excel Programming | |||
Form Unload | Excel Programming |