Finding Specific Data and modifying it

Im trying to come up with a code that finds data from a different sheet and
updates it to whatever i want:
Ex: i want to input a value in cell "B4" in sheet "Promotional" then i want
excel to serach for the matching value in sheet "users"(after clicking a
command button). when it finds the data i want to be able to change the data
to sometihing else.

Have you tried the vba Find function?

"Reggie" wrote:

> Im trying to come up with a code that finds data from a different sheet and
> updates it to whatever i want:
> Ex: i want to input a value in cell "B4" in sheet "Promotional" then i want
> excel to serach for the matching value in sheet "users"(after clicking a
> command button). when it finds the data i want to be able to change the data
> to sometihing else.

i used the find fuction in vba, but its case sensitive. How do make it not
case sensitive heres a sample of the code i have so far.

Set coolName = Worksheets("Promotional").Range("B4")
Set myCell = Worksheets("USERS").Range("A1")

With Worksheets("USERS").Range("a1:a500")
Set c = .Find(coolName)


If c = coolName Then
Worksheets("Promotional").Range("g10").Value = "test"
c.Offset(columnOffset:=5) = "testing"
End If
End With


"cush" wrote:

> Have you tried the vba Find function?
>
> "Reggie" wrote:
>
> > Im trying to come up with a code that finds data from a different sheet and
> > updates it to whatever i want:
> > Ex: i want to input a value in cell "B4" in sheet "Promotional" then i want
> > excel to serach for the matching value in sheet "users"(after clicking a
> > command button). when it finds the data i want to be able to change the data
> > to sometihing else.