ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Small grid control on User Form? (https://www.excelbanter.com/excel-programming/375347-small-grid-control-user-form.html)

Don Wiss

Small grid control on User Form?
 
On a User Form I have a small Listbox (6 rows visible). It has MultiSelect
= Multi, Column Count = 2, with the second column hidden. I'd like to add
another visible column with default weights. The user should be able to
optionally edit these weights. So is there a grid control that would allow
me to display both columns, select rows like a Listbox, allow editing of
the second column only, and have hidden columns?

Don <www.donwiss.com (e-mail link at home page bottom).

JLGWhiz

Small grid control on User Form?
 
You can set the width of the listbox display window so that only two columns
show but there will be a horizontal scroll bar automatically displayed which
can be used to display the third column. That is the default design of the
beast.

"Don Wiss" wrote:

On a User Form I have a small Listbox (6 rows visible). It has MultiSelect
= Multi, Column Count = 2, with the second column hidden. I'd like to add
another visible column with default weights. The user should be able to
optionally edit these weights. So is there a grid control that would allow
me to display both columns, select rows like a Listbox, allow editing of
the second column only, and have hidden columns?

Don <www.donwiss.com (e-mail link at home page bottom).



All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com