Prashanth_Pasunuti
New Member
- Joined
- Jun 24, 2021
- Messages
- 17
- Office Version
- 2016
- Platform
- Windows
Hello,
First assign a macro for a shape in EXCEL. When we press the macro how can we make the clicked shape as the object and find its attributes like .top, .left details etc.
What i have done.
'***********************************************
dim shp as shape
set shp = selection
with shp
shape_left = .left
shape_top = .top
end with
'*********************************************
The point is when i click on any shape the macro should run and it should give the corresponding details of that shape.
Please help
First assign a macro for a shape in EXCEL. When we press the macro how can we make the clicked shape as the object and find its attributes like .top, .left details etc.
What i have done.
'***********************************************
dim shp as shape
set shp = selection
with shp
shape_left = .left
shape_top = .top
end with
'*********************************************
The point is when i click on any shape the macro should run and it should give the corresponding details of that shape.
Please help