Control source help

[JONNEWBY]

I HAVE A FORM, iN THE FORM I HAVE A LIST BOX,
I WANNA LINK THE LIST BOX TO THE RANGE OF D1 TO D 40...
HOW WOULD I WRITE IT IN THE CONTROL SOURCE PROPERTY VALUE?


THANKS,

JONNEWBY

 

[wigi]

I HAVE A FORM, iN THE FORM I HAVE A LIST BOX,
I WANNA LINK THE LIST BOX TO THE RANGE OF D1 TO D 40...
HOW WOULD I WRITE IT IN THE CONTROL SOURCE PROPERTY VALUE?

THANKS,

JONNEWBY

You are after the RowSource property, filled in as: D1:D40

Please don't use caps when posting up a question, thanks.

 

[JONNEWBY]

sorry about the caps,
hey wigi i tried youre suggestion and it would take it it displayed msg "could not set control source property. invalid property value....

i think it my fault...
this is what i tried

=Main!d1:d10

any tips?
thnks

 

[wigi]

Please read my post carefully, I wrote RowSource property.