ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listbox (https://www.excelbanter.com/excel-programming/417864-listbox.html)

Francis Ang[_3_]

Listbox
 
I have extracted some data from a text file. I have managed to display the
extracted data in columns in the ListBox. Except for the data in the first
column, the data in the other columns are out of alignment with the column
headers. How do I align the data with the column headers?

Any help is very much appreciated. Thank you.

joel

Listbox
 
I don't know how you got the data into the listbox but you probably have
extra blnk spaces (or other invisible charaters) at the beginning or end of
the data. doing a RIM() of the data before putting the data into the listbox
will remove the blanks but not the other white characters like TAB. Without
seeing you code I cannot give you a complete solution.

"Francis Ang" wrote:

I have extracted some data from a text file. I have managed to display the
extracted data in columns in the ListBox. Except for the data in the first
column, the data in the other columns are out of alignment with the column
headers. How do I align the data with the column headers?

Any help is very much appreciated. Thank you.


Francis Ang[_3_]

Listbox
 
Thank you very much Joel. I will try your suggestion.

"Joel" wrote:

I don't know how you got the data into the listbox but you probably have
extra blnk spaces (or other invisible charaters) at the beginning or end of
the data. doing a RIM() of the data before putting the data into the listbox
will remove the blanks but not the other white characters like TAB. Without
seeing you code I cannot give you a complete solution.

"Francis Ang" wrote:

I have extracted some data from a text file. I have managed to display the
extracted data in columns in the ListBox. Except for the data in the first
column, the data in the other columns are out of alignment with the column
headers. How do I align the data with the column headers?

Any help is very much appreciated. Thank you.


dan dungan

Listbox
 
Hi Joel

I've looked but haven't found: What is a RIM() ?

Thanks,

Dan

Dave Peterson

Listbox
 
I'm guessing TRIM.

dan dungan wrote:

Hi Joel

I've looked but haven't found: What is a RIM() ?

Thanks,

Dan


--

Dave Peterson


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com