+ Reply to Thread
Results 1 to 7 of 7

Need VBA code to create sheet depends upon value select in 2 combo box list

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need VBA code to create sheet depends upon value select in 2 combo box list

    Dear Experts

    I have set of data which contains data across country code one master and rest of sheet have unquie value of country code like(AUD,AUD,BAM,BGN)

    with command box country code create sheet depends upon what country code select in combobox
    with mastersheet country code create sheet depends upon what country code select in combobox

    below listbox show up all data which is relative active to command and combobox clicks




    Regards
    manax
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Need VBA code to create sheet depends upon value select in 2 combo box list

    You haven't asked a specific question.

    Practice the steps with your macro recorder and come back with a code you need assistance with.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,523

    Re: Need VBA code to create sheet depends upon value select in 2 combo box list

    Don't understand the need for 2 the same comboboxes but try the attached with a single listbox.
    Change as you see fit.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA code to create sheet depends upon value select in 2 combo box list

    Quote Originally Posted by davesexcel View Post
    You haven't asked a specific question.

    Practice the steps with your macro recorder and come back with a code you need assistance with.
    HI Please find the image of snapshop included ,this is what i looking for
    Attached Images Attached Images

  5. #5
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,523

    Re: Need VBA code to create sheet depends upon value select in 2 combo box list

    Try this.
    Adjust placement of labels on userform as required
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA code to create sheet depends upon value select in 2 combo box list

    Thanks Alot Mate!!! Legends saved my day

  7. #7
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,523

    Re: Need VBA code to create sheet depends upon value select in 2 combo box list

    Thanks for letting us know and good luck

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need vba code to move unique rows of D:D to corresponding sheet depends upon sht name
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2016, 01:18 AM
  2. Need help on Drop down list from data validation depends upon first value select
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2013, 06:09 PM
  3. Vba list up result in column depends upon date and code
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2013, 05:01 AM
  4. Replies: 10
    Last Post: 03-17-2013, 02:28 AM
  5. Macro code to show message depends on selection from Combobox/List
    By snn3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2012, 07:00 AM
  6. Replies: 0
    Last Post: 10-16-2006, 02:32 PM
  7. Combo box list depends on value
    By Neal in forum Excel General
    Replies: 3
    Last Post: 02-01-2005, 05:06 PM

Tags for this Thread

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