Hi Tim/aa,

Thanks for your suggestions....Tim's idea of adding at runtime seems to be a
good option, it shouldn't be too much extra work and as you say it wil
give me flexibility (actually I could for example have a sheet with column a
containing button captions, and have a routine count the number and name
them accordingly, that way I can change a lot). Thanks for the suggestion,
regards, Mark



"Tim Zych" <feedback at higherdata dt com wrote in message
...
Another option is to add controls at runtime instead. If you are adding
controls as frequently as seems to suggest, it will give you a great deal
of flexibility and power. It's a big difference from how you are doing it
now, but it can take your project to a higher level.

--
Tim Zych
http://www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
Free and Pro versions available


"Mark Stephens" wrote in message
...
I have a number of controls on my user form and am cycling through them.
The problem I have is that whenever I decide to add a new member to the
group (frequently) it is given the item number according to the order it
waqs placed on the page (i.e. if it is the 50th control number 50) when I
want it to be (for exxample) number 10 since it an addition to an existing
1-9 option buttons and I want to cycle them.

Sure I can cut every other control and repaste it and then the item
number is as i want it but hopefully there is a more elegant solution ...
anyone?

Thanks and regards, Mark