Hello
I "nyef" from Syria
I want to put in the column headings "listbox" exactly as it is in the sheet, but non-contiguous columns
Hello
I "nyef" from Syria
I want to put in the column headings "listbox" exactly as it is in the sheet, but non-contiguous columns
Move the Age column to Column-C and keep the Work Column to Column-B
Select the list box in your form press F4 and set the below values in the concerned property.
Row Source
='P2'!A2:B6
ColumnHeads
True
Column Count
2
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
You can hide columns by using the columnwidths property.
The issue is more that the OP is using List and Additem to alter the contents, which you can not do once RowSource is set
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks