View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bryan Bryan is offline
external usenet poster
 
Posts: 114
Default Object Numbering

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