I am trying to update a cell with the 2nd value in a ComboBox. Please
see the code below. I get stuck in a long loop if I use only one line
of code for "ComboBox1.BoundColumn = 2", but I get into and endless
loop if I use two lines like you will see below.


Private Sub ComboBox1_Change()
ComboBox1.Width = 89.25
ComboBox1.BoundColumn = 2
Range("B10").Value = ComboBox1.Value ' Description
ComboBox1.BoundColumn = 5
Range("D10").Value = ComboBox1.Value ' Price
End Sub


Thank you


---
Message posted from http://www.ExcelForum.com/