+ Reply to Thread
Results 1 to 2 of 2

Add new combobox to userfrom and assign an event which opens another new combobox

Hybrid View

  1. #1
    Registered User
    Join Date
    03-28-2014
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Add new combobox to userfrom and assign an event which opens another new combobox

    My aim is as follows:

    - When a combobox is selected (_enter) I want it to create a new combo box just under the combobox selected
    - With this newly created combobox, if that is then selected (_enter) I then want to create another new comobox just below that one, and so on and so on until a maximum of five are created
    - With each new combobox I want to assign a list from a sheet range

    I am trying to use a class module to create further new comboboxes, however, I am getting very confused how to do this. I have seen similar examples that displays a message box when a combobox is selected and a message box is displayed.

    Any help on this would be greatly appreciated.

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

    Re: Add new combobox to userfrom and assign an event which opens another new combobox

    Welcome to the forum.
    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)

Similar Threads

  1. Control Toolbox ComboBox: Clear All cb when Worksheet Opens?
    By Agimcomas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-26-2012, 01:45 PM
  2. combobox.exit event
    By fozze in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2008, 07:27 AM
  3. combobox and workbook_change event
    By leonidas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-13-2006, 11:51 AM
  4. 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
  5. [SOLVED] 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