Thanks to Gord and Harlan for their guidance. I think I will probably
go with conditional formatting for the visual cue.
Cheers,
Kebbon

On Aug 16, 10:42 am, Gord Dibben <gorddibbATshawDOTca wrote:
Difficult to "force" a user to enter data without using some code that prevents
closing/saving the workbook if user has failed to enter the data.

Can become quite involved with contingency plans if user opens the workbook with
macros disabled.

If the future effective date is based upon some specific data entered in the
other cell you could place a formula in the second cell that returns a date.

Or you could use Conditional Formatting.

Color the cell red or somesuch.

The cell will remain red until the date is entered.

Not a "force", just a visual reminder.

Gord Dibben MS Excel MVP



On Wed, 15 Aug 2007 22:36:23 -0400, "Kebbon" wrote:
How might I force a user to enter a future effective date if they make an
entry in another cell for future price?
Thanks,
Kebbon- Hide quoted text -

- Show quoted text -