Copy and Paste text from a cell to a text box

**AnthonyJ** · 09-02-2009, 02:16 AM

I am looking for VBA code to copy text from a excel cell into a certain place in a text box. Both the cell and text box are in the same worksheet.

For the example the cell is =K15 and the Text Box is named Text Box 2 which has some text already in it and I want the text from the cell to be pasted in the text box 4 lines down.

Any help is appreciated.

**royUK** · 09-02-2009, 02:56 AM

What kind of textbox are you using?

**AnthonyJ** · 09-04-2009, 12:46 AM

The text box created from the draw tool bar.

**royUK** · 09-04-2009, 03:19 AM

Select the TextBox then in the Formula bar type =A1, any entry in A1 will appear in the TextBox

**AnthonyJ** · 09-07-2009, 04:18 AM

I appreciate your help. Thanks.

Copy and Paste text from a cell to a text box

LinkBack

Thread Tools

Rate This Thread

Display

Copy and Paste text from a cell to a text box

Re: Copy and Paste text from a cell to a text box

Re: Copy and Paste text from a cell to a text box

Re: Copy and Paste text from a cell to a text box

Re: Copy and Paste text from a cell to a text box

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions