powerranger
New Member
- Joined
- May 20, 2013
- Messages
- 16
I have been looking for a way to make a friendly interface pulling data from a 'database' spreadsheet via a filtered userform query and found a tutorial on a website that offers pretty much what I need (except Im gonna add code so Id be able to filter by more than just 3 fields). Problem is I am completely ignorant when it comes to VBA so can someone point me at the right direction. Here's the tutorial Using Excel As Your Database | Chandoo.org - Learn Microsoft Excel Online .
What I need to apply it to my spreadsheet is a way to not only select from the dynamic lists, but code I can use for columns that are filled with numerical data so say you can filter to show all rows with <0.20 in a certain column.
Also a very stupid question but where are the actual buttons placed in the code? I sort of get the hierarchy and logic within the code and with some trial and error might be able to suit it to my needs but dont see how and where are the actual buttons placed? E.g. if I added buttons in a new macro there would be a userform subsheet in the VBA tree and there's no such thing in the given example?
Sorry if it sounds confusing, as I said I am embarrassingly ignorant. Any help is MUCH appreciated.
EDIT: How do I change the title as I made a mistake?!
What I need to apply it to my spreadsheet is a way to not only select from the dynamic lists, but code I can use for columns that are filled with numerical data so say you can filter to show all rows with <0.20 in a certain column.
Also a very stupid question but where are the actual buttons placed in the code? I sort of get the hierarchy and logic within the code and with some trial and error might be able to suit it to my needs but dont see how and where are the actual buttons placed? E.g. if I added buttons in a new macro there would be a userform subsheet in the VBA tree and there's no such thing in the given example?
Sorry if it sounds confusing, as I said I am embarrassingly ignorant. Any help is MUCH appreciated.
EDIT: How do I change the title as I made a mistake?!
Last edited: