Macros

[CanadianDon]

I need to create a macro that says.. Help Me ! .... I then need that macro to only be in one specific cell...say A9... I have recorded the macro and assigned it to the button... but I can't get it only to be in A9... please help.

Thanks,

 

[paddydive]

Hi,

Do you mean that the macro should run only if you are in cell A9 ?

 

[Joe4]

What do you mean "specific to cell A9"?
What should be triggering this macro to run?
Selecting the cell A9, or editing the cell A9?

 

[CanadianDon]

If I click the button, the results should only be displayed in A9

 

[Joe4]

You mean something like this?

Sub MyMacro()
  Range("A9") = "Help Me"
End Sub

 

[paddydive]

Assign the below to a button.

Sub Helpme()

Range("A9").Value = "Help Me !"

End Sub

 

[CanadianDon]

I tried both of these, but I can click on any cell, hit the button... and it will also display in the current field I am in along with A9... any ideas on how to only show the results in A9 regardless of what cell i am in

 

[wigi]

The macro's clearly state:

Range("A9") = "Help Me"

this will only write the words in cell A9 of the active sheet.

Either you're not clear enough in your question, either you're applying/testing the code in a wrong way.

 

[CanadianDon]

thx.. I was obviously doing something wrong..it worked