none
Userform/ComboBox RRS feed

  • Question

  • Okay, new to userforms so forgive me if my question is stupid.  I created a userform and have gotten it to populate a combobox from a data range "Reps".  On this userform I want to populate 6 text boxes based on the selection in the combobox.  I've written a procedure to lookup the values but for the life of me I can't get them to populate in the userform after a click_event.

    Summarized example

    Public declaration of variables RepNum1, RepNum2 etc.

    Private Sub ComboBox1_Click()

         RepTextBox1.value = RepNum1

         RepTextBox2.value = RepNum2....etc.

    End Sub

    So what am I missing?????  is there sample code anywhere I can look at or some EASY free help.

    Monday, February 21, 2011 4:49 AM

Answers

  • Hello JJ-Iowa,

    Here's a full example of using user forms & combo boxes in Excel: http://www.contextures.com/xluserform02.html


    Cornel Croitoriu - Senior Software Developer & Entrepreneur

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    CWS SoftwareBiz-Forward.comCroitoriu.NET

    • Marked as answer by JJ-Iowa Monday, February 21, 2011 4:19 PM
    Monday, February 21, 2011 7:49 AM