Results 1 to 12 of 12

I need VBA code to make each combobox option on a userform open an excel workbook ...

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Wellingborough, England
    MS-Off Ver
    Microsoft Office 2016 Professional
    Posts
    49

    Smile I need VBA code to make each combobox option on a userform open an excel workbook ...

    Hi ... I'm new to VBA Coding but I am trying to get a userform with a combobox to open different excel workbooks when an item is selected and the command button is clicked.
    The options on the combobox are as follows ...

    QTR1 to open "Workbook A"
    QTR2 to open "Workbook B"
    QTR3 to open "Workbook C"
    QTR4 to open "Workbook D"
    Daily Audits Completed QTR1 to open "Workbook E"
    Daily Audits Completed QTR2 to open "Workbook F"
    Daily Audits Completed QTR3 to open "Workbook G"
    Daily Audits Completed QTR4 to open "Workbook H"

    I hope someone out there can help.

    Many thanks in anticipation ....
    Last edited by Jalica; 09-15-2016 at 03:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Populating ComboBox based on Option button in excel userform
    By dotchiejack in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2016, 07:41 AM
  2. how to make workbook open code specific to a sheet
    By whitwoo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2014, 01:16 PM
  3. Returning the row number of the option after the selected option in a userform combobox
    By rep67439fgs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2014, 08:07 AM
  4. UserForm help - display list of open workbooks except workbook userform code is in
    By kensweep in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-09-2014, 12:26 PM
  5. [SOLVED] Make combobox list options dependant on selection in another combobox within a userform
    By Vladimir_Dobvchenko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 05:30 AM
  6. [SOLVED] Open UserForm when workbook opens (and not the code editor)
    By GavJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 02:12 AM
  7. [SOLVED] Wanna make a Userform Close and Save - Then open a different workbook?
    By Wanting2Excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-06-2012, 08:29 PM

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