inactiveUser214710
Board Regular
- Joined
- Apr 27, 2012
- Messages
- 171
Hi everyone
I have a sort of "shapes" that I would like to use as a commandbutton or togglebutton.
What I would like do is when i click on a certain shape, it recorded in the worksheet and gives its name'shape.
How to do it?
In an attempt I used the code below without success.
I need your help.
thanks advance.
I have a sort of "shapes" that I would like to use as a commandbutton or togglebutton.
What I would like do is when i click on a certain shape, it recorded in the worksheet and gives its name'shape.
How to do it?
In an attempt I used the code below without success.
I need your help.
thanks advance.
Code:
Sub lançarShape()
Dim rng As Range
Set rng = Worksheets("sheet1").ActiveSheet.Shapes.Range(Array("bancoA1")).Cells(Row.Count, "A").End(xlUp).Offset(1, 0)
rng.Range("u2") = "A1"
End Sub