Creating a pulldown menu...

Hi Brablo,

in steps:
1) select the range of the states (Sheet2 A1:A51)
2) either Insert / Name I> / Set/Give Names > then you can gve 1 name to the
selected range (e.g. TheListOfStates)
3) then on sheet1 go to the cell, where you want the pulldown menu and
4) Data / Validation / select List and for the source just type:
=TheListOfStates and confirm with OK.
5) copy the validation to all cells you want the same pulldown list.

i am sure you can do it :-)

Best regards,
ANdras
(Hungary)


"Brablo" wrote:

> I'm not sure if I can implement this.
>
>

Hello Andras,

Thank you for your encouragement. I appreciate it. Is there any way
that you can send me the attachment to:

gestureofrespect@yahoo.com ?

Please have the combo box in sheet 1, but the data in sheet 2.

I totally appreciate this.

Hi Brablo,

i have sent it.
and still: you can do it :-)

Regards,
ANdras

"Brablo" wrote:

> Hello Andras,
>
> Thank you for your encouragement. I appreciate it. Is there any way
> that you can send me the attachment to:
>
> gestureofrespect@yahoo.com ?
>
> Please have the combo box in sheet 1, but the data in sheet 2.
>
> I totally appreciate this.
>
>

no way. the sysadmin says:

"delivery error: dd Sorry your message to gestureofrespect@yahoo.com cannot
be delivered. This account has been disabled or discontinued [#102]. -
mta307.mail.mud.yahoo.com>"

Anything else?

ANdras

"ANdras" wrote:

> Hi Brablo,
>
> i have sent it.
> and still: you can do it :-)
>
> Regards,
> ANdras
>
> "Brablo" wrote:
>
> > Hello Andras,
> >
> > Thank you for your encouragement. I appreciate it. Is there any way
> > that you can send me the attachment to:
> >
> > gestureofrespect@yahoo.com ?
> >
> > Please have the combo box in sheet 1, but the data in sheet 2.
> >
> > I totally appreciate this.
> >
> >

Hello my friend!

Thanks so much for your efforts. I have finally found out how to do
it! Before, I had never learned the text box (the box to the left of
the function box) where one creates the list. That concept was alien
to me.

I appreciate everything.

Hello Brablo,

i am glad you found the right solution!
Have fun :-)
ANdras


"Brablo" wrote:

> Hello my friend!
>
> Thanks so much for your efforts. I have finally found out how to do
> it! Before, I had never learned the text box (the box to the left of
> the function box) where one creates the list. That concept was alien
> to me.
>
> I appreciate everything.
>
>