Hello All,
Im using a listbox in UserForm, here column alignment is not ok, after 1st column there have a blank space, which is not required and in 3rd column some text is not visible,
how i can make all column proper to text visible
attachment is for you convenience
TIA
Last edited by emmr; 08-20-2019 at 04:24 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
AliGW thanks for your reply, but after several try im unable to prepare this, because my ListBox1 do not contain any Text or TextBox, i've attached my file for your convenience.
please help me by other way, thanks again
Can't you experiment with the ColumnWidths property of the listbox?
I used the column widths of the columns on the worksheet to work out the column widths for the columns in the listbox and came up with this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Norie, thanks a lot, now its working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks