Referencing Shapes

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi there,

Can anyone tell me how you can name shapes in excel, so that you can then
reference them programatically?

I'd like to include a number of small circles that change from red to green
on a given condition. At the moment I can only do this using the Selection
method, which I want to avoid.

Thanks

John
 
John,

You can either do it by selecting the shape on the worksheet and changing
the name in the Names box, or with VBA

activesheet.shapes(1).name="Bob"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cant draw connector lines between 2 shapes 3
Change Shapes (countries in map) based on conditions 1
vba powerpoint pasting named shape in selected named slides 0
Writing a logic for shape coordinates 7
Programming "Shape" objects 14
Automatically Color Autoshape and Autoshape Naming 2
searching for text within shapes 3
Colour Coded Shapes 2

Back
Top