Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring information from textbox to new spreadsheet/document
Hi
I am building a userform which monitors the data being entered and then calculates the totals etc. I would like to be able to transfer the data from the userform to a new spreadsheet or word document but can't figure out how to do this. Any help would be most appreciated. Also is there anyway of getting excel to search a range for each entry on a .txt file list? Thank BJames |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring information from textbox to new spreadsheet/document
With Worksheets("Sheet3") .Range("A1").Value = Textbox1.Text 'etc End With -- HTH RP (remove nothere from the email address if mailing direct) "bjames1001" wrote in message lkaboutsoftware.com... Hi I am building a userform which monitors the data being entered and then calculates the totals etc. I would like to be able to transfer the data from the userform to a new spreadsheet or word document but can't figure out how to do this. Any help would be most appreciated. Also is there anyway of getting excel to search a range for each entry on a .txt file list? Thank BJames |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help transferring information between work sheets! | Excel Worksheet Functions | |||
Transferring information from Publisher to Excell | New Users to Excel | |||
Transferring Information | Excel Worksheet Functions | |||
Transferring Excel Data to Word Document | Excel Discussion (Misc queries) | |||
formulas for transferring data validation information in excel 200 | Excel Worksheet Functions |