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)



"yshridhar" <(E-Mail Removed)> wrote in message
news:AA72F5D5-9016-4D77-B295-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:AA72F5D5-9016-4D77-B295-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:2FF3AA1E-EC76-475B-98FB-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:AA72F5D5-9016-4D77-B295-(E-Mail Removed)...
>> > 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
>>
>>
>>

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
<(E-Mail Removed)> 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

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
> <(E-Mail Removed)> 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
>
>

"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
> <(E-Mail Removed)> 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
>
>

"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