Home » Forums » Open Source Learning Center » Question and Answer

Response to Updating drop down based on previous cell

Submitted by AndyLitch on 7 December, 2012 - 10:14

1. Create the master lists
2. Copy and transpose the list headers to this sheet (shown in red)
3. Add a Form control - > listbox (The left one)
3a Right click the listbox and select Format Control
3B sET THE inputrange as $B$20:$B$25.. (I usually include one blank on the list)
3b Set the cell link as $G$4 - (This is the selected index of Listbox 1 shown in Yellow)
4. Go to Functions -> Name Manager on the ribbon
4a Select "New"
4b add the function OFFSET(Lists!$A$9,1,Sheet2!$G$4-2,10,1)
4c Give it a name - "SelectedList"
4d Save it and exit name manager
5. Add your second forms listbox
5a Right click it and select "Format Control"
5b For input range type SelectedList
5c For Cell Link enter $L$2

Make adjustments as necessary to customise

See attached example file..

AttachmentSize
DropDowns.xlsx17.6 KB
‹ Cyrillic in a comma-delimited file VBA - IF Sheet2 Cell = X then Copy A,B,C,D to Sheet3 Question ›
»

"Hi" and "Thanks" is required

Submitted by Argyronet on 20 December, 2012 - 12:42.

Hi,

What is your question ?
Do we have to get the title has your question ?

P.S.
"Hi" and "Thanks" is required here...
Posting an attached file to tell to us something like :
"open it and solve my problem !!!" is not welcome here for my part.
Your post does not appear to have answers... doesn't it ?
It might be a reason...

»

RE: "Hi" and "Thanks" is required

Submitted by manny on 20 December, 2012 - 14:00.

Hi,

This topic actually is a reply to the following forum question:

 excelexperts.com/updating-drop-down-based-previous-cell

And all "Thanks" are for Andy.

 

Best regards.

 

P.S. "Hi" and "Thanks" are not a rule - they are a sign of good manners. For me "Thanks" are not required. It is enough when my answers are helpful.

»

Hi Manny, Most users on this

Submitted by Argyronet on 20 December, 2012 - 14:53.

Hi Manny,

Most users on this site got a sign of good manners.
I guess what you mean but for my part, I was born with a polite spirit and when I'm looking for something where I need some help, I use the appropriate words and make at least a sentence to formalize my request.

Don't forget that our participation is voluntary and takes also time consuming.

I'm sure that Nick is agree with me.

Thank you for your message.

»

Precisely

Submitted by manny on 20 December, 2012 - 15:27.

Hi,

I totally agree with you. Just shared my opinion about what is "required" and what is not. Please do not get me wrong.

And Andy also is a volunteer. I just wanted to pay attention on that his post is not a question but is an answer.

If there is something wrong of what I'm wrote, please accept my sincerest apologies...

 

Thanks and Best regards.

 

P.S. To Andy Litch: Please excuse me for the SPAM on this topic...

»

I'm confused. In fact, this

Submitted by Argyronet on 20 December, 2012 - 15:48.

I'm confused.
In fact, this topic was alone and I supposed that it was a question.
I clicked on a link "Unanswered Forum Questions" sent directly by Nick on my mailbox :
http://www.excelexperts.com/forum/25?sort=asc&order=Replies

and the topic was appeared as a single message without nothing else.

I can see anyway that there is a some messages with a similar cases.
I going to learn read before reply next time ;o)

Sorry.

»

Sorry folks my fault ... I

Submitted by AndyLitch on 21 December, 2012 - 06:59.

Sorry folks my fault ... I will be more explicit in future..

»