having a columns look in atext box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I need to fill a text box through code and the text in it should display in
a column fashion.
I mean I would like to have 3 words on each lines and 4 rows (any made of 3
words).
i have tried working with the space function but it could be cumbersome.
Is there any other option?
Thanks,
rocco
 
Hello,
I need to fill a text box through code and the text in it should display in
a column fashion.
I mean I would like to have 3 words on each lines and 4 rows (any made of 3
words).
i have tried working with the space function but it could be cumbersome.
Is there any other option?
Thanks,
rocco
Click to expand...

That's going to be a bit tough; you'll need to either use a
fixed-pitch font or do some really fancy gymnastics to get the columns
to line up, if it's just one text string. Any way you could use three
textboxes, four rows tall, and fill each with four words separated by
vbCrLf newline characters? Just make the box edges invisible...

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split column contents (de-concantenate) 7
Combo Box, Unbound Text Boxes 2
auto populate text box based on combo box value 1
Word to Excel: Export comments with text and line number 0
Save the text box data in a certain field in the table 2
Text box displaying columns from a combo box 1
Excel VBA 1
Combo Box that fills Text Box in form 4

Back
Top