Combo - Col 2 Value

[saltkev]

Hi

Can anyone help I have a combobox with 2 columns, bound to column 1. Lets call it Combobox_1, However I need to keep the value of the selected bound column in Combobox_1, and pass the value of Column 2 to a textbox, lets call it textbox_1. This would would be undertaken on an "Exit" Event from Combobox_1.

Many Thanks

 

[RoryA]

On a sheet or userform? (never mind - no exit event on a sheet!)

Something like:

With me.combobox_1
  me.textbox_1.value = .list(.listindex, 1)
End With

 

[saltkev]

Hi

Userform

Thanks

 

[RoryA]

See my edited post - I realised after posting it couldn't be a sheet.

 

[saltkev]

Hi

Seems to work but maybe I did not explain correctly. In my Combo ther is a list of 1, 2, 3 bound in col 1. in col 2 of the same list there is a coresponding value of hello, goodby, seeyou. The Solution you gave seems to always pass the value hello. What I really need is to be able to select 2 in my combo and the value goodby be passed to my textbox


1 Hello
2 goodby
3 seeyou

Many thanks

 

[RoryA]

There must be something else interfering then because it works as it should for me. Do you have any other code that would be resetting the list or the selected item before the combobox is exited?

 

[saltkev]

Hi

yes your right, I developed a new form with just these 2 objects and everthing works. I will have to track things down.

Thanks

For the help

regards

Kev