how to select a shape obj on the sreen

  • Thread starter Thread starter EXCEL$B!!(BNEWS
  • Start date Start date
E

EXCEL$B!!(BNEWS

hi,

i often use InputBox(Prompt, Title, Default, Left, Top, HelpFile,
HelpContextId, Type) to select a range,

buti it fails to deal with a shape ,how to select a shape obj on the sreen

could you tell me,

thanks
 
strShapeName = InputBox(Prompt, Title, Default, Left, Top, HelpFile,
HelpContextId, Type)
Activeworkbook.ActiveSheet.shapes(strShapeName).select


If this post is helpful click Yes
 
Thanks for your reply.

i just like to click the shape instead of inputing the name,
i mean it is not necessary to input the name of the shape

thanks
 

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

Shapes in 2010 1
Prompt user to select a shape 4
shape remains selected 1
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
how to select a shape 6
Create shape, name shape, add text to shape 2
HelpContextID on a single field 2
Identify shape in cell 1

Back
Top