Loop workbooks and list out to user via inputbox for user to choose

**dluhut** · 06-12-2015, 10:53 AM

Hello,

I'm wondering if there's a way to listed out all workbooks that are open and have it shown in an INPUTBOX so that user can then choose via the numeric/index of the workbooks so that the macro can continue with it's code?

**JoeFoot** · 06-15-2015, 03:04 PM

try this:

Please Login or Register  to view this content.

Loop workbooks and list out to user via inputbox for user to choose

LinkBack

Thread Tools

Rate This Thread

Display

Loop workbooks and list out to user via inputbox for user to choose

Re: Loop workbooks and list out to user via inputbox for user to choose

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA List box to choose the right user form depending on the selction

[SOLVED] Repeat Inputbox if user click cancel or if user enter character not in selection criteria

Edit code to loop error msgbox and inputbox until valid date is entered by user.

Allow user to choose from list of open windows?

User to choose an item from a list

Bookmarks

Bookmarks

Posting Permissions