Hello,
I am trying to create a user form which displays multiple ListBoxes, based on the value of a variable, as shown on the attached snapshot.
In the example shown in the snapshot, the variable was 67, so I've got 67 ListBoxes.
The ListBoxes, needed to be organized in columns of 15s as shown; The Size of the user form must vary to accomodate up to 20 columns.
Could you plese advise?
Thanks!
Stating the obvious but with 20 columns the ListBoxes are going to be quite narrow.
It should be a fairly simple task using an inner and outer loop.
Create two loop variables where one will be the minimum of the number of boxes divided by 15 and the other the Integer of the number of boxes divided by 15 and rounded to the next highest number
.
Each pass through the loop should add a ListBox and set the Height and Width
then set the TopIndex and LeftIndex of each box using the loop variables
You'll need to create a scaling width variable so that you can adjust the width of each box depending on how wide your form is and how many columns you have.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard,
Thank you for looking into this.
1. What would be the script to manipulate, for example the TopIndex?
2. What would be the script to add a ListBox?
3. Where do I keep these scripts? In a Module or in the corresponding UerForm?
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks