searchbox

Hi everyone! I am quite new to VBA but i am currently working on a project where we want to make a map of the warehouse with all the storage bins and their statuses. The things i have currently done are: I, - made a table with all the storage bin location statuses (Location, how many Handling...

hi, Obvious newbie question: I'm working with a fairly large list of information, not very complex, but spread over 50-some worksheets in one workbook. I'd like to create a blank worksheet with a simple searchbox and a simple button to click. The results of the search should be displayed just...

Hi All, I have this workbook which contains multiple worksheets of data, with one key master worksheet ("Main Database") and with one worksheet called "Search Database" at the front. The first worksheet "Search Database" has a search box/button configuration. So ideally, i'd type some...

Hi All, I have this workbook which contains one summary page and numerous other worksheets which have rows containing different restricted substances according to regulations. Each of these substances have different identification numbers (CAS), EC Numbers and Regulations which are labelled as...

Hi! I created a SearchBox combo box on my form (frm_speakers). All works fine, except I want my SearchBox field to match the LastName on the form. How do I do that? Thank you!

I'm running into an issue with Sub Searchbox() I have spreadsheet with 3 columns (First Name, Last Name, and Phone#) with 25 contacts. I set up a text box and a form control SearchBox button linked to the macro that wiill search the list to match names entered in textbox and autofilter the...

Somehow I'm getting Run-time error 438 Object doesn't support this property or method. The code is placed in "ThisWorkbook" in a VBA project in Excel 2016, but I had this issue even Excel 2013 ever since I created this workbook. Private Sub Workbook_Open() ActiveWorkbook.Worksheets("User...

The following code works well to click a search button, so long as the element has an assigned tag name. Unfortunately I am not able to locate a name element for the Search button on the Yahoo home page. Can someone PLEASE advise on how to successfully re-write the code shown below to click...

Dear Sir/Madam, Good Day! My requirement is to make a filtering search box in my whroksheet so user can type desired word and it should appear with filtered row only. I googled it and found a really helpful post from Mr. Chris Newman. This great code fulfilled my requirement 90%. Here is the...

I have posted this in Ozgrid so I'm cross posting the link here as well Search Box in ListBox Please help and advise Thank you, Fadil

Hi, I am pretty new to macros and have been using the record feature a lot. I have been looking for a way to have a searchbox (which is really just a textbox) that when text is entered in and I click on my macro button that it will filter only what was entered in the searchbox. For example if...