data validation & key board usage

  • Thread starter Thread starter yshridhar
  • Start date Start date
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
 
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)
 
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
 
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)
 
Alt + downarrow to open the list.

Downarrow to scroll through the list.


Gord Dibben MS Excel MVP
 
Thank you GD. It works. As i am fast at keyboard your shortcut speeds me.
regards
Sridhar
 
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...
 
Back
Top