As has been pointed out in replies to your previous post, you have not spelt Application correctly.

Another problem is that you have used a zero in xl0n instead of the letter O - xlOn

Application.DataEntryMode = xlOn

--

John Green - Excel MVP
Sydney
Australia


"becky ryan" wrote in message ...
I would like to have my "Enter data" button put the user
into Input mode, but it's not happening. Below is what is
in the VBA editor, do you know why it doesn't work?
I did not call for the Zoom mode because my input area is
too big. THANK YOU
Here's my VBA code:
Sub Input_Assumptions()
'
' Input_Assumptions Macro
' Macro recorded 10/15/2003 by Becky Rhodes
'
Range("C6").Select
' Applicaton.DataEntryMode = xl0n
End Sub