LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 296
Default Control Index Numbers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get a index% of two numbers when they are negative or pos mrbernh Excel Worksheet Functions 2 May 19th 23 11:46 AM
Multipage Control Pages - Changing Index Value in Code misseill Excel Programming 1 July 13th 05 04:55 PM
Multipage Control Pages - Changing Index Value in Code misseill Excel Programming 0 July 13th 05 04:32 PM
Return Index of Control Object Clicked! gr8guy Excel Programming 3 May 11th 04 05:24 AM
Accesing a combobox control via it index propertie in VBA, Is itPossible? Muxer Excel Programming 3 July 30th 03 08:20 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"