If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
How to do the following by pressing the down arrow or up arrow key?
David,
To use the arrow keys, you can't be within a macro. To acheive that, use Data Validation on each cell, customizing the input message to be an appropriate prompt for each cell. Then you can use the arrow keys, and get prompted. HTH, Bernie MS Excel MVP "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 |
#3
|
|||
|
|||
How to do the following by pressing the down arrow or up arrow key?
Hi,
To use the arrow keys, you can't be within a macro. To acheive that, use Data Validation on each cell, customizing the input message to be an appropriate prompt for each cell. Then you can use the arrow keys, and get prompted. Could you tell me more about Data Validation and the other steps in your mind that may help me do the job? Thank you in advance. David |
#4
|
|||
|
|||
How to do the following by pressing the down arrow or up arrow key?
David,
Select a cell where, let's say, you want someone to enter their name. Choose Data / Validation... then on the Settings tab, choose Text Length under Allow, and set it to a minimum of 1 using the other boxes. Choose the "input message" tab, and type "Enter your name" in the message box, and make sure that you check "Show input message when cell is selected" Then in the cell below, do the same, except choose, let's say, Allow: "Whole Number" "Between" Min: "1" and Max "10" (use the four boxes). Then on the input message tab, set the message to be "Choose a number between one and ten" Then when you arrow down between those cells, you will see the two input messages, and still be able to arrow around.... HTH, Bernie MS Excel MVP "cyberdude" wrote in message oups.com... Hi, To use the arrow keys, you can't be within a macro. To acheive that, use Data Validation on each cell, customizing the input message to be an appropriate prompt for each cell. Then you can use the arrow keys, and get prompted. Could you tell me more about Data Validation and the other steps in your mind that may help me do the job? Thank you in advance. David |
#5
|
|||
|
|||
How to do the following by pressing the down arrow or up arrow key?
Thank you so much!
David Bernie Deitrick 寫道: David, Select a cell where, let's say, you want someone to enter their name. Choose Data / Validation... then on the Settings tab, choose Text Length under Allow, and set it to aminimum of 1 using the other boxes. Choose the "input message" tab, and type "Enter your name" in the message box, and make sure that you check "Show input message when cell is selected" Then in the cell below, do the same, except choose, let's say, Allow: "Whole Number" "Between" Min: "1" and Max "10" (use the four boxes). Then on the input message tab, set the message to be "Choose a number between one and ten" Then when you arrow down between those cells, you will see the two input messages, and still be able to arrow around.... HTH, Bernie MS Excel MVP "cyberdude" wrote in message oups.com... Hi, To use the arrow keys, you can't be within a macro. To acheive that, use Data Validation on each cell, customizing the input message to be an appropriate prompt for each cell. Then you can use the arrow keys, and get prompted. Could you tell me more about Data Validation and the other steps in your mind that may help me do the job? Thank you in advance. David |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Visio Shortcuts | [email protected] | Visio | 1 | December 28th, 2006 11:28 PM |
Problems with cursor and arrow | Frank Wagner | General Discussion | 1 | October 30th, 2005 06:25 AM |
insert text in arrow lines problem | Matt | New Users | 4 | May 26th, 2004 06:56 AM |
CTRL + Arrow Up or Arrow Down | Dan Cross | Formatting Long Documents | 3 | May 24th, 2004 09:11 PM |
No "arrow" on AUTOSUM button | Ron | Setting up and Configuration | 1 | December 12th, 2003 02:34 AM |