Steps to make a macro applicable to any cell that I choose

**Digestive** · 11-13-2011, 06:31 PM

Hi
I have a few questions before I create a simple macro, wondering if anyone can help?

I know there is a tab excel recommends you add to the excel ribbon in order to deal with macros, wh tis it called? I forgot! And then obv, what steps do you need to actually get it there i.e. add the tab to the ribbon?

And one more, sorry, after I have made my macro, if I want ot to be applicable to any cell that I chose, what is it that i must do? I.e. what do I have to remember to include in the process of making it?

Cheers, I know these are pretty basic questions, but I am a bit lost!

**Colin Legg** · 11-13-2011, 06:38 PM

Hi Digestive,

Please would you amend your thread title to something a little more descriptive? Perhaps, "How to show the developer tab on the ribbon?".

It's called the developer tab and to show it follow these instructions:
http://msdn.microsoft.com/en-us/library/bb608625.aspx

To make the macro applicable to any cell you choose, the actions it performs will have to refer to the ActiveCell or the Selection. The way the VBA is recorded means that the code will probably be quite close to what you need. Once you've recorded it, see if it meets your needs and, if not, post it on here (using the CODE tags) and we'll have a look at it for you?

**Digestive** · 11-13-2011, 06:53 PM

Hi Collin,
I unfortunately don't know how to do this?

**Colin Legg** · 11-13-2011, 07:05 PM

Hi,

- Go to the first post
- Click edit
- Click Go Advanced
- Change the title as necessary
- Click Save

**Digestive** · 11-13-2011, 07:31 PM

Originally Posted by Colin Legg

Hi,

- Go to the first post
- Click edit
- Click Go Advanced
- Change the title as necessary
- Click Save

It would be a simple macro pertaining to pass or fail that is then pasted to multiple worksheets of students marks, where 40 and above is a pass and below 40 a fail

=IF(D2>=40,"Pass","fail")

What would I have to do to make the macro applicable to any cell I choose? As in, what must I remember to include in the process of making the macro I think?

**Colin Legg** · 11-13-2011, 08:55 PM

Hi,

Sorry, I don't quite follow.

Suppose you select the cell G10 on Sheet1 and then you run the macro. What would you want to happen? Should it check another cell with a relative position to the selected cell (say the cell to the left, Sheet1!F10) and then put either "Pass" or "Fail" in cell G10 depending on the value F10?