Hi
dim var
var = combobox.value
range("A1").value=var

--
Regards
Frank Kabel
Frankfurt, Germany

"john q public" schrieb im
Newsbeitrag ...

if it is not one of the items from a list that the combobox is bound
to
but typed into the combobox field how do i reference that text in VBA
to do a copy/paste?


--
john q public
---------------------------------------------------------------------
---
john q public's Profile:
http://www.excelforum.com/member.php...o&userid=15782
View this thread:
http://www.excelforum.com/showthread...hreadid=273344