S
stewart
I am automating a worksheet that has been meant to fill in by hand.
The worksheet was formatted with sections that are about 9 columns
wide and 5 rows high. The columns are merged so that it is like 5
long cells. Each with bottom borders. (Makes it look like lined
paper) This section is for writing in comments. How can I create a
userform that will insert text into this space. Can I have a text box
that will input text into the cell until it is full then move down to
the next cell? How about having several text boxes on a form and as
the user types once it reaches a predefined limit it jumps down to the
next box? Let me know what other information I can give to help.
This one has me stumped.
The worksheet was formatted with sections that are about 9 columns
wide and 5 rows high. The columns are merged so that it is like 5
long cells. Each with bottom borders. (Makes it look like lined
paper) This section is for writing in comments. How can I create a
userform that will insert text into this space. Can I have a text box
that will input text into the cell until it is full then move down to
the next cell? How about having several text boxes on a form and as
the user types once it reaches a predefined limit it jumps down to the
next box? Let me know what other information I can give to help.
This one has me stumped.