Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Resizable list box columns

Status
Not open for further replies.

JTBorton

Technical User
Jun 9, 2008
345
DE
Is it possible in VBA to make a list box where a user can resize the column widths? Currently I have been creating a list box, defining the column widths and then simply slapping labels over each column that match the exact widths. Looks nice and all, but I'm looking for a way to make my list box more user friendly and flexible. What are other people doing?

-JTBorton
Another Day, Another Disaster
 

Have you considered a Grid instead of a ListBox?

Most grids (MSFlexGrid for example) will allow you to resize columns and wrap text in the cell. Plus you may color the Back and Fore color of the cells if you want to.

Have fun.

---- Andy
 
I've never heard of the flex grid. I tried to add it to my toolbox but apparently the tool is not properly licensed. But if I am running excel 2003 professional, whats with the licensing issue? Do I need to purchase the right to use that tool?

-JTBorton
Another Day, Another Disaster
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top