Setting the value of a cell from a combo box

[Nigel BEnnett]

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

 

[Tom Ogilvy]

worksheets("Sheet1").Range("H5").Value = CompanyList.Value