+ Reply to Thread
Results 1 to 5 of 5

Multiple Combobox Change Event

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Multiple Combobox Change Event

    Hello all,

    I have a Userform with 10 combobox's named:
    larguratapasol1
    larguratapasol2
    larguratapasol3
    larguratapasol4
    larguratapasol5
    Combo_CorDeFundotapasol1
    Combo_CorDeFundotapasol2
    Combo_CorDeFundotapasol3
    Combo_CorDeFundotapasol4
    Combo_CorDeFundotapasol5

    What i need is this but on all combobox's:
    Please Login or Register  to view this content.
    Same for 2,3,4,5

    Thanks in advance for your help

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Multiple Combobox Change Event


    Duplicate the "larguratapasolx_Change" macro (where "x" is a specific number for ComboBox) for others specific ComboBoxes, i.e. 2, 3, 4, 5 with appropriate values or describe your intentions in more detail because it's not known what the matters.

  3. #3
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Multiple Combobox Change Event

    I don't want to have a lot of larguratapasolX_change

    I want to put like:
    Please Login or Register  to view this content.

    With a class module we manage to do that, but i don't know how

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Multiple Combobox Change Event

    Try this.

    1 Add a new class module and name it CComboBoxes.

    2 Paste the following code in the new class module.
    Please Login or Register  to view this content.
    3 Add this declaration at the top of the userform module.
    Please Login or Register  to view this content.
    4 Add this code to the Initialize event of the userform.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  5. #5
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Multiple Combobox Change Event

    Quote Originally Posted by Norie View Post
    [/code]
    Works like a charm

    Thanks

+ 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] ComboBox Change Event error
    By natefarm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2018, 06:04 PM
  2. How to simplify Multiple ComboBox Change Event code
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2016, 05:00 AM
  3. Combobox change event
    By buhwheet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2015, 10:39 AM
  4. ComboBox Change Event Issue
    By Ezzard in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-09-2015, 02:22 PM
  5. Change event for comboBox
    By cmpcwil2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2006, 10:01 AM
  6. Combobox change event only by UI
    By Excelerate-nl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2006, 11:10 AM
  7. MsgBox in Enter event causes combobox not to run Change event
    By Richard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2006, 10:55 AM

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