I have a combo box called companylist, when I select a
value from that combo box I want it to place the value in
a cell (H5), on the change property of the combobox i
entered sheet1:h5=companylist which doesnt work, any help
would be appreciated


Thanks