Lists
 

Hello,

I would like to know how to activate a list from one sheet to another, In
other words, I have a liste on one sheet, and I am making a new sheet in
table format and I would like to get to the list that is on another sheet!
How can I do this?

Pascale

Lists
 

Select the list, copy it (Ctrl+C) and in the cell where you want the list to
start on the other sheet, paste the list (Ctrl+V)

Tyro

"Pascale" wrote in message
...
Hello,

I would like to know how to activate a list from one sheet to another, In
other words, I have a liste on one sheet, and I am making a new sheet in
table format and I would like to get to the list that is on another sheet!
How can I do this?

Pascale

Lists
 

Sorry my bad explanations, what I mean is to trnafer a scroll down list in
french they are called Liste Déroulante! How can I refer to this list from
another sheet?
TK again

"Tyro" wrote:

Select the list, copy it (Ctrl+C) and in the cell where you want the list to
start on the other sheet, paste the list (Ctrl+V)

Tyro

"Pascale" wrote in message
...
Hello,

I would like to know how to activate a list from one sheet to another, In
other words, I have a liste on one sheet, and I am making a new sheet in
table format and I would like to get to the list that is on another sheet!
How can I do this?

Pascale

Lists
 

You're talking about a list box or combo box. You'll have to create it again
on the second sheet. You can insert a form control or Active X control on
the second sheet and refer to the original list on the first sheet -
ListFillRange and set your LinkedCell to the cell you want on the second
sheet.

Tyro

"Pascale" wrote in message
...
Sorry my bad explanations, what I mean is to trnafer a scroll down list in
french they are called Liste Déroulante! How can I refer to this list from
another sheet?
TK again

"Tyro" wrote:

Select the list, copy it (Ctrl+C) and in the cell where you want the list
to
start on the other sheet, paste the list (Ctrl+V)

Tyro

"Pascale" wrote in message
...
Hello,

I would like to know how to activate a list from one sheet to another,
In
other words, I have a liste on one sheet, and I am making a new sheet
in
table format and I would like to get to the list that is on another
sheet!
How can I do this?

Pascale

Lists
 

Ok So how do I do that, and do you have these terms in french? or

"Tyro" wrote:

You're talking about a list box or combo box. You'll have to create it again
on the second sheet. You can insert a form control or Active X control on
the second sheet and refer to the original list on the first sheet -
ListFillRange and set your LinkedCell to the cell you want on the second
sheet.

Tyro

"Pascale" wrote in message
...
Sorry my bad explanations, what I mean is to trnafer a scroll down list in
french they are called Liste Déroulante! How can I refer to this list from
another sheet?
TK again

"Tyro" wrote:

Select the list, copy it (Ctrl+C) and in the cell where you want the list
to
start on the other sheet, paste the list (Ctrl+V)

Tyro

"Pascale" wrote in message
...
Hello,

I would like to know how to activate a list from one sheet to another,
In
other words, I have a liste on one sheet, and I am making a new sheet
in
table format and I would like to get to the list that is on another
sheet!
How can I do this?

Pascale

Lists
 

Don't know what you mean by "list".

What type of list?

How created?

How used?


Gord Dibben MS Excel MVP

On Mon, 4 Feb 2008 08:46:35 -0800, Pascale
wrote:

Hello,

I would like to know how to activate a list from one sheet to another, In
other words, I have a liste on one sheet, and I am making a new sheet in
table format and I would like to get to the list that is on another sheet!
How can I do this?

Pascale

Lists
 

Déroulante in English means "descend" or "unfold"

If a dropdown list is created by DataValidationList, the same list can be used
on other sheet if you first give the list a defined name.

Select the list and InsertNameDefine.

Name it MyList.

On other sheet use the =MyList in the source dialog.


Gord Dibben MS Excel MVP

On Mon, 4 Feb 2008 09:15:03 -0800, Pascale
wrote:

Sorry my bad explanations, what I mean is to trnafer a scroll down list in
french they are called Liste Déroulante! How can I refer to this list from
another sheet?
TK again

"Tyro" wrote:

Select the list, copy it (Ctrl+C) and in the cell where you want the list to
start on the other sheet, paste the list (Ctrl+V)

Tyro

"Pascale" wrote in message
...
Hello,

I would like to know how to activate a list from one sheet to another, In
other words, I have a liste on one sheet, and I am making a new sheet in
table format and I would like to get to the list that is on another sheet!
How can I do this?

Pascale

Lists
 

Something is not workin, maybe I can send you my file, And waht do you mean
by in the source dialog, do you mean in the cell?

TK

"Gord Dibben" wrote:

Déroulante in English means "descend" or "unfold"

If a dropdown list is created by DataValidationList, the same list can be used
on other sheet if you first give the list a defined name.

Select the list and InsertNameDefine.

Name it MyList.

On other sheet use the =MyList in the source dialog.


Gord Dibben MS Excel MVP

On Mon, 4 Feb 2008 09:15:03 -0800, Pascale
wrote:

Sorry my bad explanations, what I mean is to trnafer a scroll down list in
french they are called Liste Déroulante! How can I refer to this list from
another sheet?
TK again

"Tyro" wrote:

Select the list, copy it (Ctrl+C) and in the cell where you want the list to
start on the other sheet, paste the list (Ctrl+V)

Tyro

"Pascale" wrote in message
...
Hello,

I would like to know how to activate a list from one sheet to another, In
other words, I have a liste on one sheet, and I am making a new sheet in
table format and I would like to get to the list that is on another sheet!
How can I do this?

Pascale

Lists
 

Was my guess about DataValidationDropdown List correct?

If so, see this website for how to do it.

http://www.contextures.on.ca/xlDataVal01.html


Gord

On Mon, 4 Feb 2008 17:57:02 -0800, Pascale
wrote:

Something is not workin, maybe I can send you my file, And waht do you mean
by in the source dialog, do you mean in the cell?

TK

"Gord Dibben" wrote:

Déroulante in English means "descend" or "unfold"

If a dropdown list is created by DataValidationList, the same list can be used
on other sheet if you first give the list a defined name.

Select the list and InsertNameDefine.

Name it MyList.

On other sheet use the =MyList in the source dialog.


Gord Dibben MS Excel MVP

On Mon, 4 Feb 2008 09:15:03 -0800, Pascale
wrote:

Sorry my bad explanations, what I mean is to trnafer a scroll down list in
french they are called Liste Déroulante! How can I refer to this list from
another sheet?
TK again

"Tyro" wrote:

Select the list, copy it (Ctrl+C) and in the cell where you want the list to
start on the other sheet, paste the list (Ctrl+V)

Tyro

"Pascale" wrote in message
...
Hello,

I would like to know how to activate a list from one sheet to another, In
other words, I have a liste on one sheet, and I am making a new sheet in
table format and I would like to get to the list that is on another sheet!
How can I do this?

Pascale