Setting the value of a cell from a combo box
 

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

Setting the value of a cell from a combo box
 

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

--
Regards,
Tom Ogilvy

"Nigel BEnnett" wrote in message
...
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