![]() |
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. |
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. |
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. |
Listbox
Hi Joel
I've looked but haven't found: What is a RIM() ? Thanks, Dan |
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