Using a listbox response as part of the worksheets object.

[Gordonmyles]

Hi guys,

I hope someone can help please, I'm looking to use the text selected from a listbox to inform which sheet my code should look to as part of the Worksheets Object i.e.

Please Login or Register  to view this content.

Any ideas?

Thanks

[mjr veverka]

... should look to as part of the Worksheets Object ...

In what sense ? Is the code below not working for you ?
(this is the same as in your code, but more briefly)

Please Login or Register  to view this content.

[Gordonmyles]

Thanks dude, I was making that waaaay more complex than it needed to be! Also clicking the scroll button but not actually selecting the text in the dropdown from the listbox didn't help!

You're a legend!