Conditional Macro

[nebb]

I created a macro using the Tools/'Record New Macro' process. I am not familiar programming in Visual Basic. To run the macro, I do a ctrl/r. I would like to be able to do a ctrl/r and have the macro run but only under the condition that a certain cell contains a defined quantity. For example, I would like the macro to run only if cell A1 contains the numeric value 50. How might I go about doing this?

[MSP77079]

Open the macro . (Tools >> Macro >> Macros) Press “Step Into”. This opens the VB Editor with the name of the macro highlighted.

Add this line of code just below the macro's definition:

Please Login or Register  to view this content.