Correction.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
With Target
Select Case .Row
Case 5: 'do something
Case 9: 'do something else
'etc.
End Select
End With

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob" <[email protected]> wrote in message
news:[email protected]...
> I want to run a macro when the user clicks in a specific cell. In a
> personal worksheet I put a button on the page and tied a macro to the
> button. In that case there was only one button. In the present case, the
> macro needs to do different things depending on what row is clicked.
> Because someone else will be maintaining the workbook and because the data
> will change frequently (with rows being added and deleted), I don't want
to
> put a button in each row.
>
> My macro will determine its row, pull data from the same row in another
> worksheet, and display the data in a text box. I tried using a hyperlink
> from the source page to the data page, but the user didn't like that.
>
> I'm pretty sure I can get the macro to figure out the row of the cell that
> was clicked, so I really need to write only one macro. Is there a way I
can
> fire a macro when a user clicks in a cell?
>
> BTW, I thought about having the user select a cell and then use the menus
to
> launch the macro, but the user wants something simpler.
>
> Thanks,
> Bob
>
>