need to put text in a different cell if destination cell contains text.

[jacobtest]

Hello,

I have a problem and I need some help, I think this will involve a combination of IF statement and ISNUMBER functions but I'm not sure.


I want to create a button that will put specific text in a cell when pressed, or if the cell has text in it already put the text in the cell below.


This doesn't sound as if it should be too difficult, but I've tried a few things but can't make it work.


Any help or advice appreciated.

Thanks, Jacob

[bob33]

Put your request in the VBA forum for a better response.

[jacobtest]

Thanks, I'll try that now.