"Hot spot" in a spreadsheet that will duplicate the cell's entry to another cell, or to activate a macro
 

I'd like to have a date entry that I make in one cell (range named
YTDDate) be duplicated in another cell (named DealDate), without using
text boxes from the Forms or Control ToolBox, or at least anything
visible. In other words, to the user, the spreadsheet should look
unadorned, and when he enters the date in YTDDate, the DealDate cell
is similarly updated.

I seem to recall there was a way to do this through buttons that were
made invisible, which essentially triggered a macro.

If the above step is not possible, I'd also like to ask if there is a
way of triggering an input box macro when the cursor is placed on the
YTDDate. This input box would ask for the YTD date, and on OK, it
could write th same date to the DealDate cell.

"Hot spot" in a spreadsheet that will duplicate the cell's entry to another cell, or to activate a macro
 

right click sheet tabview codeinsert thismodify to suitSAVE file

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("c5")) Is Nothing Then
Range("c6").Value = Target
End If
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jayray" wrote in message
ups.com...
I'd like to have a date entry that I make in one cell (range named
YTDDate) be duplicated in another cell (named DealDate), without using
text boxes from the Forms or Control ToolBox, or at least anything
visible. In other words, to the user, the spreadsheet should look
unadorned, and when he enters the date in YTDDate, the DealDate cell
is similarly updated.

I seem to recall there was a way to do this through buttons that were
made invisible, which essentially triggered a macro.

If the above step is not possible, I'd also like to ask if there is a
way of triggering an input box macro when the cursor is placed on the
YTDDate. This input box would ask for the YTD date, and on OK, it
could write th same date to the DealDate cell.

"Hot spot" in a spreadsheet that will duplicate the cell's entry to another cell, or to activate a macro
 

One way:

In the DealDate cell:

=YTDDate


format appropriately.

In article . com,
jayray wrote:

I'd like to have a date entry that I make in one cell (range named
YTDDate) be duplicated in another cell (named DealDate), without using
text boxes from the Forms or Control ToolBox, or at least anything
visible. In other words, to the user, the spreadsheet should look
unadorned, and when he enters the date in YTDDate, the DealDate cell
is similarly updated.

I seem to recall there was a way to do this through buttons that were
made invisible, which essentially triggered a macro.

If the above step is not possible, I'd also like to ask if there is a
way of triggering an input box macro when the cursor is placed on the
YTDDate. This input box would ask for the YTD date, and on OK, it
could write th same date to the DealDate cell.