listbox edit 3.xlsm
I need to only have columns B, C, D, E, and G (these 5 columns) in the ListBox1 on the UserForm1. I want these columns to be specific to be shown.
Please help. Thank you!!![]()
listbox edit 3.xlsm
I need to only have columns B, C, D, E, and G (these 5 columns) in the ListBox1 on the UserForm1. I want these columns to be specific to be shown.
Please help. Thank you!!![]()
Hello,
One easy way would be to set the column size on the list box and put 0 for column F
![]()
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Lets just say I want columns B, C, D, N and O?
The only problem is when I view the UserForm1 I only see column B and C shown in the first and second location (column) of the ListBox. Is there a property change that needs to be made?
Is the code like this
Thank you!![]()
Please Login or Register to view this content.
Hi,
The other properties to change would be
![]()
Please Login or Register to view this content.
It still only shows 2 columns and not all 5 columns in the ListBox. Here is my code. Is there another property I need to change?
![]()
Please Login or Register to view this content.
This seems to work for the UserForm_Initialize()
![]()
Please Login or Register to view this content.
The only other issue I'm having is if I switch from Item 1 to Item 2, the OptionButton is not dynamic and doesn't update.
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks