Prev: Text Parsing with uneven lengths
Next: Macro to affect all sheets
From: Schnaka-paka on 4 Jun 2010 14:16
Hello! We have a form that we use quite often and I am attempting to put it
on Excel so that someone can just tab through it and type in their responses.
This is a type of service report and there is a large section for the
technician to describe the work they performed on a specific day.

This section should allow the text that is typed in to be "underlined". Is
there a way to set this up so that the tech is able to type one complete
paragraph (instead of typing line by line), have the text print "underlined"
AND if the amount of text typed in does not fill the entire area the unused
portion will print blank lines (underlined)?

Thank you very much for any assistance you may be able to provide! :)

From: marysully on 4 Jun 2010 16:18
This may seem like a cumbersome way of creating this section, but, create a
text box, click the underline button and hold down the spacebar to create the
lines (you may have to hit enter or shift enter at the end of each line, but
it should create the exact number of lines needed.) Text can then be typed in
Insert mode keeping the underlines intact. Hope this helps.

"Schnaka-paka" wrote:

> Hello! We have a form that we use quite often and I am attempting to put it
> on Excel so that someone can just tab through it and type in their responses.
> This is a type of service report and there is a large section for the
> technician to describe the work they performed on a specific day.
>
> This section should allow the text that is typed in to be "underlined". Is
> there a way to set this up so that the tech is able to type one complete
> paragraph (instead of typing line by line), have the text print "underlined"
> AND if the amount of text typed in does not fill the entire area the unused
> portion will print blank lines (underlined)?
>
> Thank you very much for any assistance you may be able to provide! :)
>
 | 
Pages: 1
Prev: Text Parsing with uneven lengths
Next: Macro to affect all sheets