LinkBack URL
About LinkBacks
Hello
I'm looking for a way in Userform to align the values in the ListBox columns differently.
Does anyone know the solution?
In ListBox
1.column - Center
2.column - Center
.....
7.column - Right
8.column - Right
9.column - Center
Hello
I'm looking for a way in Userform to align the values in the ListBox columns differently.
Does anyone know the solution?
In ListBox
1.column - Center
2.column - Center
.....
7.column - Right
8.column - Right
9.column - Center
Last edited by yardaz; 11-10-2017 at 12:46 PM.
Here's link to tutorial on exactly what you are looking for.
https://wellsr.com/vba/2017/excel/al...rform-listbox/
Basically, it uses Class module to manage column alignment within same listbox.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
it would be easy to use ListView instead of Listbox for different alignment between columns
1. Thank those who have helped you by clicking the Star * below the post.
2. Please mark your post [SOLVED] if it has been answered satisfactorily.
Sincerely,
Farid
True. But it's not standard set in UserForm object.
If Op wants to use ListView. Here's link to article on using it.
https://10tec.com/articles/excel-vba...-examples.aspx
Thank you, but after editing and implementation, it does not work...
Hi, yardaz,Originally Posted by yardaz
The solution provided via the link to my site from CK76 should certainly work. I'd double check to be sure it's implemented as written.
I'm on mobile at the moment so I haven't checked your original attachment. What OS and version of Excel are you using?
Ryan Wells
wellsr.com
Hi wellsr :
Win 10 and Office 2010
Hi, yardaz,
That's the same system I use. Please try the steps in the tutorial again and make sure all classes are named exactly as listed in the tutorial. :-)
wellsr:
OK.I will try.
Thank you for your time!
Hi- is there a way for this code to work with a rowsource that has already been defined? I am getting an error message "run-time error '70': could not set the List property. Permission Denied". I believe it has to do with the rowsource being set, as I was able to get the code to work for another area of code where the rowsource was not set.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks