Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Question Unanswered: Combo box value in VBA Coding

    Hello Every one..

    I have this combo box that control source as ID keys. is column count in 2 with the width of 0";1" so the txt value appear in drop down list in combo box but the default value in number and it is hidden.
    my question is how can i point the text value in VBA Code. so that it will appear in other textbox as text not as numbers?


    hope you understand want to ask..

    Thanks in advance for the quick reply..

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You can refer to the columns of a combo (or list) box using the syntax:
    Code:
    ComboName.Column(x)
    Where x is the numeric index of the column you want to address. The first (leftmost) column being Column(0).
    Have a nice day!

  3. #3
    Join Date
    Feb 2012
    Posts
    2
    That it!
    it work.. thanks Sinndho

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    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
  •