Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013

    Unanswered: text from combo box

    I have combo box in my form which have 2 columns "value" and "text" but "value" is hidden.

    I write some code in VBA and I need select only "text" from my combo box, how can I do it using VBA?
    Last edited by andrzejfox; 04-03-13 at 09:48.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    You can retrieve the content of any column of the selected row using the Column property of a combobox (or a listbox) using:
    Dim SomeVariable As Variant
    SomeVariable = Me.ComboboxName.Column(x)
    - ComboboxName is the name of the combobox
    - x is the position of the column, with 0 for the first (leftmost) column.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts