Nov 3rd, 2005, 12:18 AM
[FAQ's: OD] How to transfer data between a UserForm and the Office Application?
Depending upon the Office app your using you can read/write UserForm data to/from either behind the UserForm itself or behind the Worksheet, Document, or Presentation, etc.
Using Excel 2003 for this example:
Add two command buttons (cmdRead and cmdWrite) and two textboxes (txtRead and txtWrite).
How to read data from your worksheet and add into a textbox on your UserForm.
To write out to your Worksheet, just reverse the assignment from the UserForms control(s) to the Worksheet/Range/Cell that you want to write to.
Private Sub cmdRead_Click()
'Transfer the contents of cell A1 on Sheet1 to txtRead (UserForm)
UserForm1.txtRead.Text = Workbooks("Book1").Sheets("Sheet1").Cells(1, 1)
Private Sub cmdWrite_Click()
'Transfer the contents of txtWrite (UserForm) to Cell A1 on Sheet1
Workbooks("Book1").Sheets("Sheet1").Cells(1, 1) = UserForm1.txtWrite.Text
Last edited by RobDog888; Apr 27th, 2006 at 02:50 PM.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Microsoft MVP 2006-2011
Office Development FAQ (VBA, VB 6, VB.NET, C#)
Senior Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it!
• Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007
Dec 19th, 2009, 03:37 PM
Re: [FAQ's: OD] How to transfer data between a UserForm and the Office Application?
yeah, that didn't work, it kept saying that Worksheet wasn't declared.
Click Here to Expand Forum to Full Width