LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code/Function to Look at Previous Entry to Validate Data Steve Excel Worksheet Functions 6 February 9th 09 07:06 AM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing [email protected] Excel Discussion (Misc queries) 0 March 20th 08 12:45 PM
add data to combo box in excel then invoke macro Richard Excel Worksheet Functions 1 December 11th 05 08:50 PM
zip code entry mphope Excel Worksheet Functions 1 April 5th 05 01:11 PM
zip code entry Margo Excel Worksheet Functions 0 April 5th 05 04:07 AM


All times are GMT +1. The time now is 06:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"