Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2018, 09:05 PM
andxie andxie is offline Excel Macro: Multiple Search and Post in Excel Sheet Windows 7 64bit Excel Macro: Multiple Search and Post in Excel Sheet Office 2013
Novice
Excel Macro: Multiple Search and Post in Excel Sheet
 
Join Date: May 2018
Posts: 15
andxie is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 05-27-2018, 11:28 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel Macro: Multiple Search and Post in Excel Sheet Windows 7 64bit Excel Macro: Multiple Search and Post in Excel Sheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 05-27-2018, 11:48 PM
andxie andxie is offline Excel Macro: Multiple Search and Post in Excel Sheet Windows 7 64bit Excel Macro: Multiple Search and Post in Excel Sheet Office 2013
Novice
Excel Macro: Multiple Search and Post in Excel Sheet
 
Join Date: May 2018
Posts: 15
andxie is on a distinguished road
Default

Here is the sample file. I would like it to reveal the results in a listbox or on an empty excel sheet

Thanks
Attached Files
File Type: xlsm Book1.xlsm (17.6 KB, 14 views)
Reply With Quote
  #4  
Old 05-29-2018, 02:03 PM
p45cal's Avatar
p45cal p45cal is online now Excel Macro: Multiple Search and Post in Excel Sheet Windows 10 Excel Macro: Multiple Search and Post in Excel Sheet Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

See attached.
Very basic code.
No checks carried out.
New sheet added every time the search button is pressed.
Attached Files
File Type: xlsm MSOfficeForums39212Book1.xlsm (22.1 KB, 12 views)
Reply With Quote
  #5  
Old 05-29-2018, 05:26 PM
andxie andxie is offline Excel Macro: Multiple Search and Post in Excel Sheet Windows 7 64bit Excel Macro: Multiple Search and Post in Excel Sheet Office 2013
Novice
Excel Macro: Multiple Search and Post in Excel Sheet
 
Join Date: May 2018
Posts: 15
andxie is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 05-29-2018, 11:31 PM
ArviLaanemets ArviLaanemets is offline Excel Macro: Multiple Search and Post in Excel Sheet Windows 8 Excel Macro: Multiple Search and Post in Excel Sheet Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

An example without VBA and form.
Attached Files
File Type: xlsm Book1.xlsm (23.6 KB, 8 views)
Reply With Quote
  #7  
Old 05-29-2018, 11:48 PM
ArviLaanemets ArviLaanemets is offline Excel Macro: Multiple Search and Post in Excel Sheet Windows 8 Excel Macro: Multiple Search and Post in Excel Sheet Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Attached Files
File Type: xlsm Book1.xlsm (23.9 KB, 11 views)
Reply With Quote
  #8  
Old 05-30-2018, 04:38 AM
p45cal's Avatar
p45cal p45cal is online now Excel Macro: Multiple Search and Post in Excel Sheet Windows 10 Excel Macro: Multiple Search and Post in Excel Sheet Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by andxie View Post
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?
See attached.
Still no checks
Note commented-out macro called UserForm_Terminate which can be enabled to delete the extra sheet when the form is dismissed.
Attached Files
File Type: xlsm MSOfficeForums39212Book1.xlsm (22.5 KB, 11 views)
Reply With Quote
  #9  
Old 05-30-2018, 06:28 PM
andxie andxie is offline Excel Macro: Multiple Search and Post in Excel Sheet Windows 7 64bit Excel Macro: Multiple Search and Post in Excel Sheet Office 2013
Novice
Excel Macro: Multiple Search and Post in Excel Sheet
 
Join Date: May 2018
Posts: 15
andxie is on a distinguished road
Default

@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
Reply With Quote
  #10  
Old 05-31-2018, 01:31 AM
p45cal's Avatar
p45cal p45cal is online now Excel Macro: Multiple Search and Post in Excel Sheet Windows 10 Excel Macro: Multiple Search and Post in Excel Sheet Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by andxie View Post
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?
Very probably, but without details it's impossible to say which would be the best way.
Reply With Quote
  #11  
Old 05-31-2018, 05:21 PM
andxie andxie is offline Excel Macro: Multiple Search and Post in Excel Sheet Windows 7 64bit Excel Macro: Multiple Search and Post in Excel Sheet Office 2013
Novice
Excel Macro: Multiple Search and Post in Excel Sheet
 
Join Date: May 2018
Posts: 15
andxie is on a distinguished road
Default

Alright , Thank you for your help
Reply With Quote
Reply

Thread Tools
Display Modes


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
Excel Macro: Multiple Search and Post in Excel Sheet How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? ADubin Excel Programming 3 02-08-2015 04:57 AM
Excel Macro: Multiple Search and Post in Excel Sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft