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: 170
Default accept input and move active cell?

Totally new to macros and VBA, but may need then to accomplish a task.

Need to direct data entry into specific cell locations in Excel 2000.
Already have unlocked cells and protected worksheet. Need to find a way to do
something like this:
go to B2 on open sheet
accept data entry
Go to C4, accept data
Go to E4, accept input
and so and so on

I used the record macro process, but I can't find a way to cause the macro
to pause for input, between the go to commands. Therefore the result is that
It goes straight to the ending location!

I know it's do-able, just don't understand how! Any and all pointers
appreciated!

Thanks in advance

 
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
move from active cell offset in macro april Excel Discussion (Misc queries) 5 October 18th 09 05:02 PM
Move active cell to same location on each worksheet BeanoKid Excel Discussion (Misc queries) 3 April 15th 08 11:29 PM
Can a cell be set to accept input only once? Simple Gifts Excel Worksheet Functions 1 April 4th 06 05:08 AM
Input mask for active cell Lee Hunter Excel Discussion (Misc queries) 2 January 25th 06 08:57 PM
need to Copy or Move to active cell from specified range kaream Excel Discussion (Misc queries) 2 December 14th 05 08:12 AM


All times are GMT +1. The time now is 03:10 AM.

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"