User forms - choosing location of your data to be shown in your user form

Hi excelforums,

Do any of you more experienced users know how to change how to decide where the userform gets the data to be shown in its listbox. I have spent a good deal of time trying to figure it out on my own but I still don't know how.

The userform takes the data found in columns 'B' and 'D' of the "ME List" worksheet, but I would like to know how to change it so the userform takes the data from columns 'A' and 'D' instead. You can bring up the userform by clicking on either columns 'C' and 'D' of "Purchase Req"
The userform code is:

Please Login or Register  to view this content.

Thank you so much,

Jason

Hi jasonbwt,

I’m not very experienced with macros. Most of what I have learned is from here.
That being said,
If you click on the properties of the userform in the visual basic screen and scroll down near the bottom, you will find “Row Source”. In the box next to it, put in where the data is.

As an example, I have the data in T1:T13. For the Row source I have: T1:T13.

I found that it was easier to edit the data this way than in the macro.
I also have a userform that has the data in a different worksheet than where the userform pops up but in the same workbook. In that case I “ranged name” the data and used that name in the row source.

Mike

All you should need to do is change the columns referred to in the code that populates the list.

Actually, now that I've had a closer look at the code all you need is 2 changes.

The first one is changing the column to filter on.

Please Login or Register  to view this content.

[/code]
The second is to change the column widths so the first column is visible but the 2nd isn't.

First of all, thank you to you 3 who helped me. You actually all helped me.

Originally Posted by Norie

All you should need to do is change the columns referred to in the code that populates the list.

Actually, now that I've had a closer look at the code all you need is 2 changes.

The first one is changing the column to filter on.

Please Login or Register  to view this content.

[/code]
The second is to change the column widths so the first column is visible but the 2nd isn't.

Hi Norie i had spent ages changing the number from FillLists i.e. FillLists 1,2,3,4 etc..but never worked. Now i changed the column widths too and it works. I obviously didnt understand how the column widths work but your solution works!!!!!!

Thank you!,

oh and mrl i tried your way but wasn't quite sure if it worked or not because of the code and the row source. i got an error. anyway maybe u shud explore Norie's method too.
Jason

@ jasonbwt

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.