VBA code: how to invoke data entry mode
 

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

VBA code: how to invoke data entry mode
 

I noticed a typo. Should be Application not Applicaton.

--
Dianne

In ,
Becky Ryan typed:
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

VBA code: how to invoke data entry mode
 

Becky,

Change:
Applicaton
to
Application

(minor typo)
Using 'Option Explicit' at the top of your modules will help catch most of
these.

--
sb
"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