Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to do the following by pressing the down arrow or up arrow key?
Hi,
I wrote a macro to do the following thing: I move from B1 to B100 and for each stop over a B cell, an input box prompts me to key in a number to be the value in the current B cell. I press enter to move to the next cell. Then, an input box popps up asking me for a number again. The process goes on until B100. Now, I want to do a slightly different thing: I want to move up and down the B cells casually and easily by pressing the down arrow or up arrow key without pressing the enter key at all. Is it possible to do that? Let me give you an example. Suppose, I am on B3. An input box shows up and asks me for a number. I enter 3. I want 3 to be B3's value, and I hope to move up one cell by pressing the up arrow key or down one cell by pressing the down arrow key without using the enter key at all. Is doing that possible? Thanks. David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to do the following by pressing the down arrow or up arrow key?
Look in Excel help at OnKey and sendkey. Define uparror to send a return
and move up one cell, down arror to send a return and move down one cell. Untested suggestion, but the only thing I can think of. -- Regards, Tom Ogilvy "cyberdude" wrote in message oups.com... Hi, I wrote a macro to do the following thing: I move from B1 to B100 and for each stop over a B cell, an input box prompts me to key in a number to be the value in the current B cell. I press enter to move to the next cell. Then, an input box popps up asking me for a number again. The process goes on until B100. Now, I want to do a slightly different thing: I want to move up and down the B cells casually and easily by pressing the down arrow or up arrow key without pressing the enter key at all. Is it possible to do that? Let me give you an example. Suppose, I am on B3. An input box shows up and asks me for a number. I enter 3. I want 3 to be B3's value, and I hope to move up one cell by pressing the up arrow key or down one cell by pressing the down arrow key without using the enter key at all. Is doing that possible? Thanks. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in excel, pressing shift+ctrl+arrow no longer works? any idea why | Excel Worksheet Functions | |||
Excel 2007 - Macro (VB) code for arrow down & arrow up | Excel Discussion (Misc queries) | |||
Using end-arrow down or end-arrow up in a macro | Excel Discussion (Misc queries) | |||
why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) | |||
How to do the following by pressing the down arrow or up arrow key? | Excel Discussion (Misc queries) |