Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax- drop down menu contents wanted
Could someone explain how to get the drop-down menu for this line ? TabStrip1.Tabs(1). Trying to see what's allowed. The only one found so far is caption. Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax- drop down menu contents wanted
I can't get intellisense to work either. But perhaps two things can help:
1. Put a breakpoint in your code, then add a watch on Tabstrip1.Tabs(1). You will see the properties available on the Tab Object. 2. Search the VBA Help for "Tab Object", or, Click on the TabStrip Control, click F1 and find your way to the Tab Object. "kirkm" wrote: Could someone explain how to get the drop-down menu for this line ? TabStrip1.Tabs(1). Trying to see what's allowed. The only one found so far is caption. Thanks - Kirk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax- drop down menu contents wanted
Kirk,
As I type the "(" in "TabStrip1.Tabs(", Intellisense comes up with "Item(varg) As Object". As it is the generic Object, the IDE has no way to know which properties, methods etc are available. If it had be declared "As SomeClass", then the Type Library could yield the correct info. That's my take anyway... NickHK "kirkm" wrote in message ... Could someone explain how to get the drop-down menu for this line ? TabStrip1.Tabs(1). Trying to see what's allowed. The only one found so far is caption. Thanks - Kirk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax- drop down menu contents wanted
Kirk,
Open the Object Browser (F2), choose "MSForms" in the top dropdown and enter "tabstrip" in the 2nd dropdown. Then in the lower left-hand box click on "tab" and its properties will show in the lower-right hand box. At least, it works that way in XL 2003. hth, Doug "kirkm" wrote in message ... Could someone explain how to get the drop-down menu for this line ? TabStrip1.Tabs(1). Trying to see what's allowed. The only one found so far is caption. Thanks - Kirk |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax- drop down menu contents wanted
On Thu, 8 Mar 2007 20:37:59 -0800, "Doug Glancy"
wrote: Kirk, Open the Object Browser (F2), choose "MSForms" in the top dropdown and enter "tabstrip" in the 2nd dropdown. Then in the lower left-hand box click on "tab" and its properties will show in the lower-right hand box. At least, it works that way in XL 2003. Thanks Doug (and everyone). I got there :) Looks like what I wanted isn't there. I'm using variable width tabs on my tabstrip. The only way I can (see to) set a varying size it to use strng$(xx,32) in the name. It seemed a bit fudgy so I was hoping for a better method. But it works. Thanks - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Wanted: Syntax for Filename changed without impacting Macro | Excel Programming | |||
Reset menu wanted | Excel Programming | |||
Func wanted for drag/drop in ListBox | Excel Programming | |||
Drag/drop - calc of ListBox row wanted | Excel Programming |