Adding a Line using VBA

  • Thread starter Thread starter tkemo569
  • Start date Start date
T

tkemo569

I have a user entering data in a certain cell. I would like to draw a
line that corresponds to this number? How would you could this.

Say the Information is entered in cell B10. I would like the line to
start in C10 and be the length that is entered in cell B10

Thanks for the Help,

Tim
 
You can get most of what you need by turning on the macro recorder and
drawing a line manually. then turn it off and look at the code. Modify the
code to reflect the position and length parameters based on the cell
utilized for entry. This can be detected using the change event.

http://www.cpearson.com/excel/events.htm
 
Back
Top