Adding a Line using VBA
 

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


--
tkemo569
------------------------------------------------------------------------
tkemo569's Profile: http://www.excelforum.com/member.php...o&userid=29573
View this thread: http://www.excelforum.com/showthread...hreadid=492731

Adding a Line using VBA
 

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

--
Regards,
Tom Ogilvy



"tkemo569" wrote in
message ...

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


--
tkemo569
------------------------------------------------------------------------
tkemo569's Profile:
http://www.excelforum.com/member.php...o&userid=29573
View this thread: http://www.excelforum.com/showthread...hreadid=492731

Adding a Line using VBA
 

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


"tkemo569" wrote in
message ...

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


--
tkemo569
------------------------------------------------------------------------
tkemo569's Profile:
http://www.excelforum.com/member.php...o&userid=29573
View this thread: http://www.excelforum.com/showthread...hreadid=492731