simora
01-10-2010, 04:15 AM
Trying to search across multiple worksheets for a value that I put into a userform textBox4
I can get the address, but how do I fill the form with values from the same row from the found address.
It finds a match like
firstAddress = c.Address
This correctly shows me the sheet name, row & column
MsgBox (sh.Name & " " & c.Row & " " & c.Column)
From this information, I need to have textBox3.valu be 1 column to the left & textBox2 be 2 columns to the left of the found address.
There should only be 1 match, but if there's more, then the error should show in TextBox1
Thanks
I can get the address, but how do I fill the form with values from the same row from the found address.
It finds a match like
firstAddress = c.Address
This correctly shows me the sheet name, row & column
MsgBox (sh.Name & " " & c.Row & " " & c.Column)
From this information, I need to have textBox3.valu be 1 column to the left & textBox2 be 2 columns to the left of the found address.
There should only be 1 match, but if there's more, then the error should show in TextBox1
Thanks