Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 300
Default 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).
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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).

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Textbox added to Form at runtime too small, can't control size andchange event won't trigger RCGUA Excel Worksheet Functions 2 December 10th 08 09:34 PM
Textbox added to Form at runtime too small, can't control size andchange event won't trigger RCGUA Excel Worksheet Functions 0 December 10th 08 07:48 PM
Adding a control to a User Form scantor145[_22_] Excel Programming 1 October 17th 05 09:27 PM
Spreadsheet Control on User Form Paul Worthington Excel Programming 0 June 29th 04 03:09 PM
Control Order on User Form AKoodray Excel Programming 4 December 30th 03 09:30 PM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"