Picking value from dropdown list column

L

Lee

Hi,

Supposing you wanted a text box to show the value in the
second column of a combo box thats called cboList. You
would make the control source of your text box:

= cboList.Column(1)

The column numbering starts with zero so the second
column is number 1.

Regards,

Lee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo or list box 0
Unable to display values in 2nd list box from 1st list box selection 2
How to get the value of non-bound combo box column? 5
Combo Box Showing only bound column when choice is made -- the new normal? 2
WORD VBA Search and switch to advanced ... 1
Auto-populate comboBox with value from Row Source 2
How do I add a COLUMN to combo box 1
combo box - bound column 2

Top