Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concantenate and align info??
I am trying to concantenate information from three columns into one s
that the info contained in the three columns can be viewed on a use form. The form works great but because the cells hold information o different lengths it displays the information all unaligned as below: h1&" "h2&" "h3 $14 blah blah etcetc $142 blah blah etcetc $1433 blahblah etcetc Is it possible to establish the string lenth for each h instead o trying to make it space so that the information would align? I thank you in advance for any suggestions -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concantenate and align info??
One way:
Dim h As String h = Left(h1 & Space(20), 20) & Left(h2 & Space(20), 20) & h3 In article , depuyus wrote: I am trying to concantenate information from three columns into one so that the info contained in the three columns can be viewed on a user form. The form works great but because the cells hold information of different lengths it displays the information all unaligned as below: h1&" "h2&" "h3 $14 blah blah etcetc $142 blah blah etcetc $1433 blahblah etcetc Is it possible to establish the string lenth for each h instead of trying to make it space so that the information would align? I thank you in advance for any suggestions. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concantenate and align info??
depuyus,
What about using a multi column list box instead ? NickHK "depuyus " wrote in message ... I am trying to concantenate information from three columns into one so that the info contained in the three columns can be viewed on a user form. The form works great but because the cells hold information of different lengths it displays the information all unaligned as below: h1&" "h2&" "h3 $14 blah blah etcetc $142 blah blah etcetc $1433 blahblah etcetc Is it possible to establish the string lenth for each h instead of trying to make it space so that the information would align? I thank you in advance for any suggestions. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concantenate and align info??
Thank you so much! I really appreciate the help. I love the code.
didnt realize that I could use a multi column list box. I define multiple columns in the range and it only showed the first column so assumed you couldnt. I will check into that. Thank you both -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Align dollar symbol, align currency symbol... | Excel Discussion (Misc queries) | |||
Concantenate Help | Excel Worksheet Functions | |||
Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
What is short-Cut forleft align and Right align? | Excel Discussion (Misc queries) | |||
Concantenate using VBA? | Excel Programming |