Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
refer a cell text in b1 and extract remaing text from a1 Narnimar Excel Discussion (Misc queries) 4 April 3rd 10 12:30 PM
Change Text Box Color When Typed In Paperback Writer Excel Discussion (Misc queries) 5 December 5th 06 07:41 PM
Inserting characters into text already typed [email protected] Excel Discussion (Misc queries) 2 February 24th 06 02:11 AM
capture text typed in Combo Box seeker Excel Programming 0 May 4th 04 06:14 PM
How do I get cursor position and text being typed? Kallepalle Excel Programming 2 February 19th 04 05:49 PM


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"