Hi,
I inserted a combo box in a sheet ("Sheet1"
an I linked it to a cell "A1".
It seem that depending of what I have selected in my combo box I am getting the index number i.e. the item number in my combo box list. Any way I can retrieve the value in "A1"?
Ideally if a different value is selected in the combo list it should update A1 .
Reciproquely, if A1 is changed to a different value in the combo list, it should automatically change the selection in the combo box.
Thanks
I inserted a combo box in a sheet ("Sheet1"
It seem that depending of what I have selected in my combo box I am getting the index number i.e. the item number in my combo box list. Any way I can retrieve the value in "A1"?
Ideally if a different value is selected in the combo list it should update A1 .
Reciproquely, if A1 is changed to a different value in the combo list, it should automatically change the selection in the combo box.
Thanks