Excel vba experts please help!!!

[[zhugong]]

Im using excel 2013..
1) i insert a shape (say a line) at cell A1..
2) cell b1-b13 will be red will A1 is a line
3) i wan to click it and it will change to a square
4) A2 will also follow A1..
5) after clicking line to change to square, cell b1-b13 will change colour from red to black
6) when click on the square again, it will change back from square to line
7) cell b1-b13 will change from black to red also

Anyone knows how to write?

 

[natnai]

I write for you just pay 50 dollars

Sent from Xiaomi MI 3W using GAGT

 

[[zhugong]]

I write for you just pay 50 dollars

Sent from Xiaomi MI 3W using GAGT

I wanna write myself but i just need to know how to start by clicking on it to change from square to line...

 

[ChadHogan]

You should record the Macro first with the Excel In-Built Tools. After doing the manual process you can extract your needed codelines from the recorded Macro. Of course, you will need to do it more dynamic but it often helps to get the specific syntax for special operations like drawing, diagrams, etc..

 

[KnightNiwrem]

I write for you just pay 50 dollars

Sent from Xiaomi MI 3W using GAGT

Undercutting natnai - 49.90.