data validation & key board usage

Y

yshridhar

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
 
B

Bob Phillips

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)
 
Y

yshridhar

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
 
B

Bob Phillips

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)
 
G

Gord Dibben

Alt + downarrow to open the list.

Downarrow to scroll through the list.


Gord Dibben MS Excel MVP
 
Y

yshridhar

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

supoch14

yshridhar said:
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
Click to expand...
 
Top