View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default Object Numbering

Bryan

You can name the object whatever you like (almost). So why not just name
them as you create them starting with 100. Even better, don't create and
delete the objects. Make them Visible/Invisible based on your needs.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Bryan" wrote in message
...
Is there a way to change the object numbering - always start from the same
number?

Reason - I draw a group box with 5 buttons inside for each user (0-12)

If I have 0 users, then I delete all the objects.

Right now, I have a kludge in that I write to a hidden cell the last

object
number and the number of objects. But I only check for the last 4 digits

of
the object number (and after playing around several times I'm approaching

5
digits), and I really don't want to go into string manipulation to get a
valid number.

I'd like to always start user 1 with drawing object #100

Thanks,

Bryan