Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 114
Default Userform List box to Text Box

Hi
I have a list box on a userform that is populated with names on selecting a
name from the list box how would I be able to show the selected name in a
text box on the same userform eg TextBox1. = Listbox1.name selected
--
Many thanks

hazel
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 292
Default Userform List box to Text Box

Hi

Textbox1.Text = Listbox1.Text

in the Listbox1_click event

HTH. Best wishes Harald

"Hazel" skrev i melding
...
Hi
I have a list box on a userform that is populated with names on selecting
a
name from the list box how would I be able to show the selected name in a
text box on the same userform eg TextBox1. = Listbox1.name selected
--
Many thanks

hazel



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
Text entries behaving like numbers jkiser Excel Discussion (Misc queries) 12 August 30th 06 09:29 PM
How can I wrap text in a drop down list? wrapped Excel Worksheet Functions 0 January 25th 06 05:53 PM
Sort text list alphabetically using a formula paddyyates Excel Worksheet Functions 3 December 21st 05 03:12 AM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 07:10 PM


All times are GMT +1. The time now is 08:15 AM.

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

About Us

"It's about Microsoft Excel"