The same thing happened to me this morning. The Worksheet_Change functtion
doesn't reference Target, thereofre it doesn't get called. try adding to the
routine
msgbox(Target). I bet this will work.

"Anthony" wrote:

Hi
I have created a very simple userform which I want to be displayed each time
any cell is used. I have tried typing this code..

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False
Roulette.Show

Application.EnableEvents = True
End Sub

in the worksheet code module, but when I hit the enter key after adding some
data into any cell the user form doesn't show

any ideas why??