View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dianne Dianne is offline
external usenet poster
 
Posts: 107
Default 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