HELP / Macro

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.

 

 

By: Dan

737 thoughts on “HELP / Macro

  1. 졸업증명서위조

    Wonderful blog! I found it while surfing around on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I ave been trying for a while but I never seem to get there! Cheers

  2. App Para Assistir Animes No Pc

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

Comments are closed.