How do i refer to the text typed in a combobox?
 

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

--
john q publi
-----------------------------------------------------------------------
john q public's Profile: http://www.excelforum.com/member.php...fo&userid=1578
View this thread: http://www.excelforum.com/showthread.php?threadid=27334

How do i refer to the text typed in a combobox?
 

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

How do i refer to the text typed in a combobox?
 

combobox1.Value

--
Regards,
Tom Ogilvy

"john q public" wrote in
message ...

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