Hi Shetty,

<<But this can be done only for some predefined cells. Can it be done for
any cell (not predefined)

If you wanted to do it for any cell on the worksheet, you could use On
Error Resume Next to blow by anything that wasn't a valid macro name. Not my
preferred way of programming, but it would work:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Application.Run Target.Value
End Sub

<<or without Worksheet_Change event ?

You could set the legacy Worksheet.OnEntry property to a macro that did
the same thing, but that isn't conceptually different from using the
Worksheet_Change event. There aren't any other ways that I can think of
right off the bat.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm