quest re VBA: how to Input mode?

  • Thread starter Thread starter becky ryan
  • Start date Start date
B

becky ryan

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
 
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
 
Back
Top