Hi All,
I have a worksheet in which I need to run a macro everytime the value in a cell (say Cell B1) is changed.
[Note: The calculation mode in the workbook is required to stay manual]
I know that I can do this using a TextBox, but I am trying to see if I can do without it to preserve the look and feel of the worksheet. Uning a text box would work for me, provided I could embed the textbox in cell B1 such that a Tab press in cell A1 could move me to the text box. I've run out of ideas on this and would really appreciate your help. Thanks!
Manish
I have a worksheet in which I need to run a macro everytime the value in a cell (say Cell B1) is changed.
[Note: The calculation mode in the workbook is required to stay manual]
I know that I can do this using a TextBox, but I am trying to see if I can do without it to preserve the look and feel of the worksheet. Uning a text box would work for me, provided I could embed the textbox in cell B1 such that a Tab press in cell A1 could move me to the text box. I've run out of ideas on this and would really appreciate your help. Thanks!
Manish