Hi
I have a list of data say for example name, price and code.
I want to create a userforms with three boxes where the user can enter either of the 3 above parameters.
I then want a listbox to be populated with ALL of the results in my data sheet. I also need to columns headings in the list box.
I'm having a bit of trouble finding the code for this.
Could someone help me please?
Thanks
you can only have column headers in a listbox if you bind it to a worksheet range using the rowsource property, which you won't be able to do if you want to return only some records-unless you copy those records to a separate worksheet.
Josie
if at first you don't succeed try doing it the way your wife told you to
OK, even if headers are not availible, just getting the results would be useful.
a sample workbook would be helpful. you haven't provided any detail so far to indicate where any of the information is ;-)
Sure thing, here you go.
It's just a basic example but should illustrate what I need.
Please, anyone?
here is a sample. I changed your forms listbox to an activex one since you want multiple columns and set all the controls to not move or size with cells because the code uses an autofilter. personally I would recommend using an actual userform or putting the controls onto a separate sheet for your actual workbook
Awesome, great stuff, thanks!
Yeah i'll def use a proper form in my final version.
Is there no way I can have the column headings in the list? I've seen an example of this online but I have no idea how it's doing it as the code is very complex in comparison to your example.
Please Login or Register to view this content.
if you want them in the list that's easy but if you want real column headers (ie they can't be selected) then you can only do that by copying the data somewhere else
Yeah sorry, in the list is what I meant.
Would you be able to ammend the sample you sent me please to include it?
Thanks
change the module1 code to
and I reckon that oughta do itPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks