Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Wed, 17 Aug 2005 14:44:22 +0200, "Jean-Yves"
wrote: Hi Richard In general, it is better practice to rename the controls yourself and then adress the control by its name iso by index. another way is to create your controls at run time and record their name in an array. Regards Jean-Yves Thanks Jean, (and Bob earlier), The only reason I was using the index number was that I did domething different with the first eight listed checkboxes than with the rest. I was using a simple Select statement assuming I could rely on the control index number as the Select Case i.e. Case<8. I now see I can't and will follow the advice you suggest. Incidentally, is it possible to see a control index number directly, or can this only be done by writing a bit of code to identify the control name of each control index number? Incidentally2. Are control index numbers always base zero? Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get a index% of two numbers when they are negative or pos | Excel Worksheet Functions | |||
Multipage Control Pages - Changing Index Value in Code | Excel Programming | |||
Multipage Control Pages - Changing Index Value in Code | Excel Programming | |||
Return Index of Control Object Clicked! | Excel Programming | |||
Accesing a combobox control via it index propertie in VBA, Is itPossible? | Excel Programming |