How to line a DropDwn w/a Named Range?

J

JDP@Work

I have a range on my sheet titled MC

I have a drop down form control that I'd like to have use that named range as
its source.

TIA

JeffP...
 
S

Simon Lloyd

I,m not entirely sure what you want but if you have named a range yo
can have a dropdown list box by using DATA, VALIDATION, then choos
allow list then in the range box type =MC!

Don't forget to highlight the range you want the listbox to work o
befroe you choose validation.

Hope this helps!

Simo
 
K

keepITcool

simon,
in your enthousiasm you're destroying the syntax <g>

op should NOT type

=MC!

but

=MC

or in data/validation/listsource press [f3] go get a list with names


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
S

Simon Lloyd

Thanks Keepitcool!

I remember now the ! is when you name a sheet, well ive only been a
this VB/VBA lark about 7 weeks so not bad though...but glad you wer
there to point me in the right direction <g>.

Humbly yours,

Simo
 
K

keepITcool

the ! is used when adding name objects to point to the current sheet.
but ALWAYS comes BEFORE the name, never AFTER

it's also used for relative range references in named formulas


worksheets(1).activate

names.add "!localName", activecell
names.add "globalName", activecell

names.add "doubleA", "=!a1*2"
names.add "doubleB", "=b1*2"

worksheets(2).activate
names.add "!localName", activecell
names.add "globalName", activecell




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
J

JDP@Work

Thanks to all....

I had

Data!$A$14:$A$19

Now... I have

Data!Action

Where Action is the named range. Much more better and cleaner for if and when I
have a process to insert into Action I'll have new values for my referring combo
box.

TIA

JeffP.....
 
Top