need help with this piece of code for a list box
Posted by steven scaife on August 23, 2001 8:30 AM
That is the code i am using below. The problem that i am having with it is that when the line in the list box is selected it shows a name, a price and a code. when the button is pressed to place the line into the worksheet only the name is placed into the active cell. I also need the next two cells to be populated with the code and price. any ideas would be appreciated.
selectedtext = .List(.ListIndex)
' Display the selected value in a message box.
ActiveCell.Value = selectedtext