Set up macro in Excel to choose active row?

K

Kerri

I have an Excel spreadsheet with multiple worksheets. I want to be able to
set up a macro within one of the worksheets that will allow me to do the
following:
Once I type in a barcode number in a cell (say b3 of worksheet 2) and click
on the macro button it will:

1 open another worksheet in the file (worksheet 1)
2 find the number from the active cell (b3 of worksheet 2)
3 highlight the entire row in worksheet 1 where the barcode number was found
4 turn the text in that row green
5 save the worksheet
6 go back to worksheet 2

I don't know any visual basic code. I have in the past used macros to do
generic steps, none that required it to find a number and do something with
it. My problem is that it does the action only to the row the initial macro
was recorded in.

Any help would be greatly appreciated.
 
K

Kerri

Thanks for your quick reply. I copied and pasted the code, but it turned the
line
...Cells.Font.ColorIndex = 4 red in the code window
and would not perform the action. I deleted one of the periods in front of
the word Cells and it would somewhat perform the action in that it did change
the barcode in sheet1 green, but not the entire row that contained the
barcode and it did not save sheet1 to keep it green. The next time I put in
a barcode number in sheet2 it changed the previous insert back to black and
the only barcode that was green was the one just inserted. Thanks so much
for your help, it is at least a start.
 
G

Gord Dibben

Kerri

A typo

Should only be one period in the line

..Cells.Font.ColorIndex = 4 red


Gord Dibben MS Excel MVP
 
Top