| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation Update Validation Selection | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
