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
|