#1
|
|||
|
|||
Excel Macro: Multiple Search and Post in Excel Sheet
I have a project wherein the user will enter the specific characteristics of a product then it will show the user the name of the product. It's like entering multiple data in a userform and show the results in the excel sheet.
I have multiple textboxes where each is a different characteristic, then a button to search for the product. I don't how I could code this in vba. Could someone help me? |
#2
|
||||
|
||||
Hi and welcome
please post a sample sheet showing what you have and eventually expected results. ( click " Go advanced - Manage attachments I will transfer this post to the proper forum
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Here is the sample file. I would like it to reveal the results in a listbox or on an empty excel sheet
Thanks |
#4
|
||||
|
||||
See attached.
Very basic code. No checks carried out. New sheet added every time the search button is pressed. |
#5
|
|||
|
|||
Thank you, it was the result I imagined but
What if only one textbox was filled and the others are not? and also how could I only post the results on only one sheet and it won't add every time the search button is clicked? Thanks |
#6
|
|||
|
|||
An example without VBA and form.
|
#7
|
|||
|
|||
The same, but when any parameter on sheet Report is empty, all products with this parameter > 0 and other parameters matching are displayed. I.e. when all parameters on Report sheet are left empty, all products from DataTable are displayed on Report sheet.
|
#8
|
||||
|
||||
Quote:
Still no checks Note commented-out macro called UserForm_Terminate which can be enabled to delete the extra sheet when the form is dismissed. |
#9
|
|||
|
|||
@p45cal, Thank you it works perfectly,
May I ask If this can be done on multiple data sheets that has other parameters wherein it does not have on the first sheet? Thanks |
#10
|
||||
|
||||
Very probably, but without details it's impossible to say which would be the best way.
|
#11
|
|||
|
|||
Alright , Thank you for your help
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Single embedded excel sheet for multiple graphs in PowerPoint | GOCPT | PowerPoint | 1 | 07-26-2017 04:20 AM |
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? | ADubin | Excel Programming | 3 | 02-08-2015 04:57 AM |
Inputing Text from Excel sheet to multiple Word documents and Visio File | Jazz43 | Office | 1 | 05-30-2013 02:08 PM |
Excel - search Multiple Values (HELP!) | duskdjl | Excel | 4 | 03-28-2013 01:11 AM |
confirmation popup on excel sheet macro | mark-gabb | Excel Programming | 3 | 12-22-2011 01:16 AM |