Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Textbox data to cell

Dim SomeCell as range

Set somecell = activesheet.range("a1")
somecell.value _
= me.textbox2.value & ", " & me.textbox1.value & " - " & me.textbox3.value



Pats wrote:

My userform has a TextBox for First Name , Last Name and Employee #. What I
need to know is, how can I put the contents of all 3 Textboxes into one cell?

Example:

Last Name, First Name - Employee #


--

Dave Peterson
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
How can i import data from a cell in another sheet, into a textbox Hans the norwegian Excel Worksheet Functions 1 August 19th 09 01:39 PM
Load ws cell data into a textbox via click on chart datapoint a Charts and Charting in Excel 4 January 23rd 09 08:08 PM
Textbox Data IsNumeric RyanH Excel Programming 5 October 13th 08 07:50 PM
Copy Textbox data to Textbox in Other File Troubled User Excel Programming 2 October 6th 08 06:42 PM
Copy excel data (inc. textbox data) into Word Sarah (OGI) Excel Discussion (Misc queries) 0 August 14th 07 05:00 PM


All times are GMT +1. The time now is 08:43 PM.

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"