findall

Hello everyone, I'm trying to adjust Excel's "Find All" feature so that it searches the entire workbook by default, rather than only the current sheet. I’ve researched this and found that there are third-party tools and VBA macros that can accomplish this, but I’d prefer not to use them. One of...

Hi All, I want to select all the cells having the same font ("AmplitudeTF"). The recording option gives the following: With Application.FindFormat.Font .Name = "AmplitudeTF" .Subscript = False .TintAndShade = 0 .ThemeFont = xlThemeFontNone End With But...

Hi, I have this macro which looks for the unit 'ps' in Column Y and multiplies 1E+12 with the corresponding data in column AC. When it tries to multiply 1E+12, it throws a type mismatch error. Below is the code. Sub Multiply_Tdata() ' ' Change the value of the data (AC) column - multiply by...

I just learned how to add in Excel a couple months ago and, although I'm doing the best I can with google, VBA is not easy for me to work with yet. So, while I certainly appreciate any sort of help, explanation-heavy answers would be doubly appreciated! The excel file I've attached should...

Any help is appreciated. I am trying to use VBA to find all values in Sheet2 based on a list that changes in Sheet1 and copy the values to Sheet3. I would like Sheet3 to change everytime the list changes on Sheet1. Here is an example: Sheet1: Here are the names (A2:A10) that change based on a...

I have searched several sites with no avail. If anyone can see what I'm doing wrong in this VBA code I would greatly appreciate it. I am getting an object required error at: Set c = .Find(strFind, LookIn:=xlValues) Private Sub SearchData() Dim strFind As String Dim FirstAddress As...

I'm a bit of a visual basic noob, and may be in over my head here... I'm having difficulty using the following "repeating search code" to store the row information of the results, allowing me to display them on a user form label box later. Private Sub getVendorButton_Click() 'Search Prompt...

Hi, I would like a script which will put all found search items in a listbox. Basically I search for whatever value I type in textbox1 and I want listbox1 to return all the results. my search code is: Cells.Find(What:=TextBox1.Value, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _...

Hello All Thanks for helping me out before. I was wondering if you could help me understand this piece of code I am trying to use. I have a database that uses a userform to enter data. I am trying to decipher the search function I found on the internet so I can integrate it with my code but...