Combo Box for UserForm - Excel Mac 2011

  • Hi everyone,


    I have an existing userform that I programmed with all labels and text boxes. I want to change a few of the text boxes to pull-down menus with finite possible options, but I cannot find a way to program combo or list boxes to do this. The boxes will be simple -- one will have "Yes" and 'No" as an option and one will have "High" "Medium" and "Low" as options.


    I already have the command buttons for Enter, Clear, and Close programmed . . . any help on how to add values to the combo box?


    Thank you,
    Corcelle

  • Re: Combo Box for UserForm - Excel Mac 2011


    It should be as simple as:

    Code
    Me.Combobox1.List = Array("Yes", "No")


    in the Initialize event of the form for example. (on a Mac you can't use Rowsource)

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Re: Combo Box for UserForm - Excel Mac 2011


    PERFECT! Thanks a ton . . . I was in the right neighborhood but couldn't quite get it.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!