combobox dynamic range doesn't work as expected

[florin_excel]

Greetings all,
I'm a total newbie, this is my first post so please be kind.

I've embedded a combobox (active x) in a worksheet and intend to populate it with a changing number of items based on user's decision. I've put some code together as below, but it doesn't work. Could any of you please help?

Please Login or Register  to view this content.

File attached.

[JosephP]

your code does work but because you have put it in the change event you have to type something into the control in order to populate the list

[florin_excel]

Hi JosephP, thanks for looking into my query.
I've said I'm a newbie, so exactly typing that "something" into the control box is my problem
Could you elaborate, please?

[JosephP]

my point is that you should use a different event-worksheet_activate or workbook_open perhaps or combobox1_dropbuttonclick

[florin_excel]

Many thanks, JP. I just woke up it works with the dropbuttonclick procedure.
Are you doing the 3rd shift or just sleepless in utah?

[JosephP]

collaborating with uk office at the moment so I work strange shifts! not really sure what time or day it is any more ;-)

[florin_excel]

Good luck and thanks again.
This might help http://thejazzgroove.com/

[JosephP]

thanks :-)

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save