Populating a UserForm ListBox with all Open workbooks

Hi,

This code works for me in Excel 2010. See the attached...

Could you please upload your workbook

WorkBookUpdater.xlsm

AJ:

Yours work for me as well.

Above is my workbook.

Thank you,

Josh

Weird, because I literally copied your code and pasted into a new workbook...

Will let you know what I find

Your ListBox is called WkbkChoicesListBox, not WkbkListBox

Well, how silly was that?

Thanks AJ!!!!

Can you see where the wbChoice doesn't like to be given the value of WkbkChoicesListBox.Value?

Or is the trick there to call it as a String, not a Workbook?

The idea is that I want to modify the chosen workbook. So, I'd like to Activate it then do some column inserts, some formula copying, etc....

Thank you,

Josh

Use this code:

Please Login or Register  to view this content.

Rock on! AJ, you're my hero for the evening.

Thank you,

Josh

Hahaha you're welcome

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks