|To answer your original question:|
I want to get today's date in a column of cells, but only when there is text in the adjacent cell.
There is a way, without the use of a Macro, try this:
First we have to set up the workbook so our magic will work.
Click the Microsoft Office button
Click on the Excel Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Formula button in the left hand pane
In the right hand pane
Check the box next to: Enable iterative calculation
Change the number in the Maximum Iterations box to 1
Now that the workbook is set up properly:
Cell B1 will contain your Current Date & Time, so enter this formula in cell B1
Now enter any Text or number in Cell A1 and Today's date should appear in cell B1.
Make sure you have cell B1 formatted as a Date Cell.
To change the date in cell B1, delete the text/number in call A1
then re-enter any text or number.
Excel considers a <SPACE> a valid character, so spacing over the text/number in A1 will leave the date in place.
This behavior can be an advantage, you don't need to Show anything in cell A1 or a disadvantage, depending on what your doing.
See how that works for you.