Hi im new to excel, cut a long story short i want to make to make a button so that every time i click it, it makes a shape, in this case the shape is a simple line. So for example, i want to create the button, and then whatever cell i click i want the line to appear in it.
ive tried recording macro, making the line and assigning it to a button, but it seems to rotate the line in a opposite direction and lock it to one cell only. e.g I want the line to run from top right of A1 to bottom Left, however when i create the macro it rotates it from how i want it to Top left of A1 to bottom right, it also locks it to the one cell
i want to use many of these lines, in all different cells so if anyone can help, should add also im an excel newbie so this VBA coding doesnt make sense to me 🙂
if anyone understands what i mean and can help me out that would be much appreciated.