+ Reply to Thread
Results 1 to 2 of 2

msgbox(select one of the open workbooks)

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    12

    Question msgbox(select one of the open workbooks)

    Hi Team,

    I'm creating a macro for an Excel user.

    I want a msgbox to some up with a list of the open workbooks and for the user to be able to select the workbook with the information they want.
    I will then transfer some information from the selected workbook to the new workbook.

    Can you please help?

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: msgbox(select one of the open workbooks)

    Hello Basimma

    I will help you a little bit just for start.....

    Here I created a Userform and a list box
    The list box will display all open workbook as you said.
    When you click a workbook from the list it will go there.
    Hope this will help you.

    But If you have already build some vba you better attach it so other members could work around it.
    Attached Files Attached Files
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1