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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XL97: Display 2-columns in list box field

Status
Not open for further replies.

sjpistolesi

Programmer
Jun 6, 2002
71
US
I have a user form, which displays only the 1st of 2 columns once item(s) is selected. How can I display the values from both cells in the range selected?

Thanks,
Sandy
 
Hi sjpistolesi,

Change the ColumnCount property of your ListBox to 2 and adjust the ColumnWidths property so that the columns are sized as you want.

Enjoy,
Tony
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top