| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text transfer
I have a worksheet that I would like to be able to enter freeform text
(Possibly a text box) into an estimate then have that text transfer to another worksheet to be entered into the body of a proposal. Is this possible and if so, how? -- Thanks, Marc Shaw |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text transfer
worksheets("Proposal1").Range("F12").Value = _
Worksheets(Sheet1").TextBoxes("Text Box 1").Value where Text Box 1 is a textbox from the drawing toolbar. -- Regards, Tom Ogilvy "Marc Shaw" wrote: I have a worksheet that I would like to be able to enter freeform text (Possibly a text box) into an estimate then have that text transfer to another worksheet to be entered into the body of a proposal. Is this possible and if so, how? -- Thanks, Marc Shaw |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text transfer
Thanks Tom,
Is it possible to go from a text box on one sheet to a text box on the other sheet? -- Thanks, Marc Shaw "Tom Ogilvy" wrote: worksheets("Proposal1").Range("F12").Value = _ Worksheets(Sheet1").TextBoxes("Text Box 1").Value where Text Box 1 is a textbox from the drawing toolbar. -- Regards, Tom Ogilvy "Marc Shaw" wrote: I have a worksheet that I would like to be able to enter freeform text (Possibly a text box) into an estimate then have that text transfer to another worksheet to be entered into the body of a proposal. Is this possible and if so, how? -- Thanks, Marc Shaw |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text transfer
worksheets("Proposal1").Textboxes("Text Box 1").Value = _
Worksheets("Sheet1").TextBoxes("Text Box 1").Value -- Regards, Tom Ogilvy "Marc Shaw" wrote: Thanks Tom, Is it possible to go from a text box on one sheet to a text box on the other sheet? -- Thanks, Marc Shaw "Tom Ogilvy" wrote: worksheets("Proposal1").Range("F12").Value = _ Worksheets(Sheet1").TextBoxes("Text Box 1").Value where Text Box 1 is a textbox from the drawing toolbar. -- Regards, Tom Ogilvy "Marc Shaw" wrote: I have a worksheet that I would like to be able to enter freeform text (Possibly a text box) into an estimate then have that text transfer to another worksheet to be entered into the body of a proposal. Is this possible and if so, how? -- Thanks, Marc Shaw |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text transfer
The exact forumla that I am using is as follows
=worksheets("Proposal").Textboxes("ProposalText"). Value=worksheets("Estimate").Textboxes("EstimateTe xt").Value and I continue to receive an error message stating: "Refernce is not valid. -- Thanks, Marc Shaw "Tom Ogilvy" wrote: worksheets("Proposal1").Textboxes("Text Box 1").Value = _ Worksheets("Sheet1").TextBoxes("Text Box 1").Value -- Regards, Tom Ogilvy "Marc Shaw" wrote: Thanks Tom, Is it possible to go from a text box on one sheet to a text box on the other sheet? -- Thanks, Marc Shaw "Tom Ogilvy" wrote: worksheets("Proposal1").Range("F12").Value = _ Worksheets(Sheet1").TextBoxes("Text Box 1").Value where Text Box 1 is a textbox from the drawing toolbar. -- Regards, Tom Ogilvy "Marc Shaw" wrote: I have a worksheet that I would like to be able to enter freeform text (Possibly a text box) into an estimate then have that text transfer to another worksheet to be entered into the body of a proposal. Is this possible and if so, how? -- Thanks, Marc Shaw |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text transfer
You posting this in Excel.Programming. so I provided VBA code. It won't
work in worksheet. And if you are using it in code, then you don't use a leading equal sign. -- Regards, Tom Ogilvy "Marc Shaw" wrote: The exact forumla that I am using is as follows =worksheets("Proposal").Textboxes("ProposalText"). Value=worksheets("Estimate").Textboxes("EstimateTe xt").Value and I continue to receive an error message stating: "Refernce is not valid. -- Thanks, Marc Shaw "Tom Ogilvy" wrote: worksheets("Proposal1").Textboxes("Text Box 1").Value = _ Worksheets("Sheet1").TextBoxes("Text Box 1").Value -- Regards, Tom Ogilvy "Marc Shaw" wrote: Thanks Tom, Is it possible to go from a text box on one sheet to a text box on the other sheet? -- Thanks, Marc Shaw "Tom Ogilvy" wrote: worksheets("Proposal1").Range("F12").Value = _ Worksheets(Sheet1").TextBoxes("Text Box 1").Value where Text Box 1 is a textbox from the drawing toolbar. -- Regards, Tom Ogilvy "Marc Shaw" wrote: I have a worksheet that I would like to be able to enter freeform text (Possibly a text box) into an estimate then have that text transfer to another worksheet to be entered into the body of a proposal. Is this possible and if so, how? -- Thanks, Marc Shaw |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Format Transfer | Excel Discussion (Misc queries) | |||
| how do i transfer html text to standard text? | Excel Discussion (Misc queries) | |||
| Transfer text to another spreadsheet | New Users to Excel | |||
| How I can transfer numbers in to text | New Users to Excel | |||
| Can data from one ws transfer to another IF cell has text? | Excel Worksheet Functions | |||
Linear Mode
