Adding a Line using VBA

[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

 

[Tom Ogilvy]

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

 

[Frederick Chow]

How about a simple underline? Sounds it will do it.