data validation & key board usage
 

Hello everybody
I protected my worksheet with only B1 to be editable. In B1 I created
datavalidation|list. What i want is to use Keyboard ie. arrow keys instead
of mouse. Is it possible. My worksheet contains Worksheet_change macro.
Thanks to all
regards
Sridhar

data validation & key board usage
 

To do what? You can just type the value in, it doesn't have to be mouse
selected.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"yshridhar" wrote in message
...
Hello everybody
I protected my worksheet with only B1 to be editable. In B1 I created
datavalidation|list. What i want is to use Keyboard ie. arrow keys
instead
of mouse. Is it possible. My worksheet contains Worksheet_change macro.
Thanks to all
regards
Sridhar

data validation & key board usage
 

This list is of ID nos of the students. I want to just scroll down the list
instead of entering one by one from key board.
regards
Sridhar

"Bob Phillips" wrote:

To do what? You can just type the value in, it doesn't have to be mouse
selected.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"yshridhar" wrote in message
...
Hello everybody
I protected my worksheet with only B1 to be editable. In B1 I created
datavalidation|list. What i want is to use Keyboard ie. arrow keys
instead
of mouse. Is it possible. My worksheet contains Worksheet_change macro.
Thanks to all
regards
Sridhar

data validation & key board usage
 

Once DV is clicked, the down arrow does that.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"yshridhar" wrote in message
...
This list is of ID nos of the students. I want to just scroll down the
list
instead of entering one by one from key board.
regards
Sridhar

"Bob Phillips" wrote:

To do what? You can just type the value in, it doesn't have to be mouse
selected.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"yshridhar" wrote in message
...
Hello everybody
I protected my worksheet with only B1 to be editable. In B1 I created
datavalidation|list. What i want is to use Keyboard ie. arrow keys
instead
of mouse. Is it possible. My worksheet contains Worksheet_change
macro.
Thanks to all
regards
Sridhar

data validation & key board usage
 

Alt + downarrow to open the list.

Downarrow to scroll through the list.


Gord Dibben MS Excel MVP

On Sun, 9 Dec 2007 21:01:00 -0800, yshridhar
wrote:

Hello everybody
I protected my worksheet with only B1 to be editable. In B1 I created
datavalidation|list. What i want is to use Keyboard ie. arrow keys instead
of mouse. Is it possible. My worksheet contains Worksheet_change macro.
Thanks to all
regards
Sridhar

data validation & key board usage
 

Thank you GD. It works. As i am fast at keyboard your shortcut speeds me.
regards
Sridhar

"Gord Dibben" wrote:

Alt + downarrow to open the list.

Downarrow to scroll through the list.


Gord Dibben MS Excel MVP

On Sun, 9 Dec 2007 21:01:00 -0800, yshridhar
wrote:

Hello everybody
I protected my worksheet with only B1 to be editable. In B1 I created
datavalidation|list. What i want is to use Keyboard ie. arrow keys instead
of mouse. Is it possible. My worksheet contains Worksheet_change macro.
Thanks to all
regards
Sridhar

data validation & key board usage
 

"Gord Dibben" wrote:

Alt + downarrow to open the list.

Downarrow to scroll through the list.


Gord Dibben MS Excel MVP

On Sun, 9 Dec 2007 21:01:00 -0800, yshridhar
wrote:

Hello everybody
I protected my worksheet with only B1 to be editable. In B1 I created
datavalidation|list. What i want is to use Keyboard ie. arrow keys instead
of mouse. Is it possible. My worksheet contains Worksheet_change macro.
Thanks to all
regards
Sridhar

data validation & key board usage
 

"yshridhar" wrote:

Hello everybody
I protected my worksheet with only B1 to be editable. In B1 I created
datavalidation|list. What i want is to use Keyboard ie. arrow keys instead
of mouse. Is it possible. My worksheet contains Worksheet_change macro.
Thanks to all
regards
Sridhar