combo box and .listindex
I have a combobox on a user form that I populate using the .additem method.
I want the listindex to be displayed on a worksheet that is hidden. I can
do this by assigning the .listindex property to the sheet and cell.
However, when the user selects an item from the combo box, the .listindex
integer also appears in whichever cell was active (wherever the cursor is in
the active sheet) when the user triggered the userform.
My question, how do I prevent the .listindex from being copied to the active
cell?
TIA,
D
|