NextYearSox
Active Member
- Joined
- Oct 24, 2003
- Messages
- 287
I need to draw a rectangle in the row my cursor is located. I am using VB code as follows:
ActiveSheet.Shapes.AddShape(msoShapeRectangle, horizontal start, vertical start, length, thickness).Select
The horizontal start, length, and thickness is identical for all rectangles I draw. How can I use the cursor position to define the vertical start?
ActiveSheet.Shapes.AddShape(msoShapeRectangle, horizontal start, vertical start, length, thickness).Select
The horizontal start, length, and thickness is identical for all rectangles I draw. How can I use the cursor position to define the vertical start?