Hi. How might I apply a worksheet change event to the active cell? On
my worksheet, a user will enter a number in a cell (column B). I want
to make that current cell a hyperlink to an application (the app will
open and go to the entered number). The general hyperlink concept
works just fine, and I've looped through the column on my large
spreadsheet and applied the hyperlinks to existing numbers in column
B, but moving forward, I'd like for the hyperlink to automatically be
created after the user clicks enter or arrows right.

The problem is the worksheet change event sees the 'ActiveCell' as the
cell to the right or below the cell where the number was entered.

Is there another way to do this that I'm not seeing or thinking about?
Thanks for any ideas.

Frank