Please provide a FULL and CLEAR explanation of the problem. Are you saying, without actually saying, that you want a URL that you can use directly that would be equivalent to searching via that field? If so then what site are we talking about, as I can't read it from that blurry picture? If you enter a search term and click the search button, what do you see in the address bar? For many sites, that will be the URL you use directly to search.
Again, give us the URL of the site. Your picture is too blurry to read and we shouldn't have to guess. I already asked a for a FULL and CLEAR explanation and you failed to provide it again. I also asked other specific questions that you have just ignored.
I assume that English is not your first language so it can be hard, but that generally means that you need more words to explain clearly, not fewer. Don't try to get away with writing as few words as possible. Write as many words as are required to explain fully.
as you can see in the screenshot i need the link to the search area so I paste data hereby excel automation
Sub SearchOnGoogle()
Dim rng As Range
Dim rowRange As Range
Dim cell As Range
Dim searchString As String
Dim url As String
' Set the range to search from column D to column J, starting from row 2
Set rng = ActiveSheet.Range("D2:J" & ActiveSheet.Cells(Rows.Count, "D").End(xlUp).Row)
' Loop through each row
For Each rowRange In rng.Rows
' Initialize the search string
searchString = ""
' Concatenate the values from each cell in the row
For Each cell In rowRange.Cells
searchString = searchString & " " & cell.Value
Next cell
' Trim leading/trailing spaces
searchString = Trim(searchString)
' Construct the Google search URL
url = "https://www.google.com/search?q=" & WorksheetFunction.EncodeURL(searchString)
' Open the URL in the default web browser
ThisWorkbook.FollowHyperlink url
Next rowRange
End Sub
]Here is a link of the Google search box[/B] "https://www.google.com/search?q=" I need to put the link of these search boxes instead of Google search box
More short explanation
I need a Mindbody website search box link
Last edited by Kamran aj; May 30th, 2023 at 10:12 AM.
Reply With Quote
