button

[cmccabe]

I am using excel 2003 and wondering if a button can be created that will run 2 codes simultaneously. The first code looks for a specific text in a range of cells and colors the coressponding values. The other code checks to see if the value is within a acceptable range and then highlights the value in a particular way.

I have an example but can not attach it. Thanks.

 

[Smitty]

You can't run code simulataneoulsy, but you can run one procedure after the other:

Sub foo()
  Macro1
  Macro2
End Sub

Then attach that code to your button.

HTH,