Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with combobox output
I have a combobox that is being filled by data located on sheet3. The
combobox is setup for 3 columns. I would like to have the combobox display only the values in column 1 and in two other textboxes be able to show the values of column 2 and column 3. I am able to get the combobox to display fine, and one of the textboxes to display it's column. When I try to activate the second textbox, it won't work. The code that I am trying to use is: Private Sub cboCustomer_Change() cboCustomer.ColumnCount = 3 cboCustomer.BoundColumn = 2 txtContact.Text = cboCustomer.Value cboCustomer.BoundColumn = 3 txtPhone.Text = cboCustomer.Value End Sub I would appreciate any direction you might suggest. TIA Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help for getting output | Excel Discussion (Misc queries) | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
diverting output | Excel Worksheet Functions | |||
Formating output. | Excel Discussion (Misc queries) | |||
Too much output... PLEASE HELP! | Excel Programming |