+ Reply to Thread
Results 1 to 3 of 3

One program for initialize in change event in many Combobox

  1. #1
    Registered User
    Join Date
    09-26-2021
    Location
    Poznan;Poland
    MS-Off Ver
    2007 and 2019
    Posts
    1

    One program for initialize in change event in many Combobox

    I looking for more efective solution for UserForm with many ComboBox's.
    This is UserForm
    obraz_2021-09-26_221536.png
    Each of the Change Event of each ComboBox should copy date from Sheet ( with use fuction to get data) to first and secend TextBox; the third TextBox is for User to put data. So I have code for this (comment are in polish sorry) :

    Please Login or Register  to view this content.
    I would like to run this program whenever one of ComboBox is change, but with not copy it to ever ComboBox1_Change; ComboBox2_Change ect.
    Is ther any way to do this, or do you have other Idea.
    Sorry For my english; is bit rusty
    Last edited by KaBorys; 09-26-2021 at 04:33 PM.

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: One program for initialize in change event in many Combobox

    that's why a ClassModule is made for.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: One program for initialize in change event in many Combobox

    see big yellow banner - upload your workbook - then an appropriate answer will follow.
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. Deleting a row, run Combobox change event
    By jschneiter2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2020, 12:00 AM
  2. How to use the UserForm Initialize event to Initialize 3 listboxes in the same userform
    By Pimp_mentality in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-16-2016, 02:59 PM
  3. Combobox change event
    By buhwheet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2015, 10:39 AM
  4. Change event for comboBox
    By cmpcwil2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2006, 10:01 AM
  5. [SOLVED] 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
  6. 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
  7. [SOLVED] Change event causes program to freeze
    By KobusD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-30-2005, 12:05 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