List Box in Userform/ Sheet Array

[zimbo109]

Hi,

Is it possible to populate listbox 1 on userform2 from sheets 12 (inclusive) onwards with the value of A3 on each sheet ?

[royUK]

problems will arise if the sheet order is changed,something like

Please Login or Register  to view this content.

[zimbo109]

Thanks Roy, .Index is an invalid or unqualified reference??

[royUK]

Sorry,rushing about at the moment

Please Login or Register  to view this content.

[zimbo109]

Great as always- Thanks Roy.

[royUK]

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

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

[snb]

or (faster)

Please Login or Register  to view this content.

Still you can choose the Value property - .cells(3,1) - or - .cells(3.1).Value or the Text property - .cells(3,1).Text - of cell A3.

[zimbo109]

Thanks snb, the value that A3 returns is that also of the sheet name. From the listbox/combobox that is now showing the results of A3 in all ws after sheet 12 can I then select the item so that, that sheet becomes the active sheet?

[snb]

in that case you can also use:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[zimbo109]

Thank you works perfectly.