Barry -

Record a macro where you copy / paste special values that you want. Then
have the button call the macro you just recorded.

--
Daryl S


"Barry" wrote:

Using Excel 2003 in Windows XP sp3

My workbook has two worksheets. On worksheet 1 in cell B3 (Named Payperiod1)
is a date value. On worksheet 2 in cell F9 (Named StartDate) is a date field.
Using a button called "Pay_Period_1" on worksheet 1 I'd like to assign the
value in worksheet 1 cell b3 to Worksheet 2 f9 Or something like PayPeriod1 =
StartDate.