Windows XP How to Modify Selected Shape

Joined
Sep 11, 2009
Messages
1
Reaction score
0
Hello,

I have a spreadsheet application that puts a shape on a row. The row height is carefully set to perfectly fit the shape, but I want the user to be able to nudge up the row height and shape height in case they want to write more in the shape.

So I want to write a macro that will increase row height by a small amount and then increase the height of the shape in that row a comparable amount. But I am stuck trying to get the name of the shape that the user would like to nudge.

I have tried
Dim SelectedShape As String
SelectedShape = ActiveSheet.Shapes(Application.Caller).Name
but I get run time error 13: type mismatch

Any suggestions?
 

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

Top