About Us

Is it possible to (using a macro) to set the value of one
text box on Sheet 1 to be the value of another text box
on Sheet B?

This seems like it should be very simple to do but i
can't figure it out.

Jeff

kotharu[_6_]

its very simple jeff..

its looks like

sheets("Sheet1").text1.text=sheets("Sheet2").text2 .text

regards
kotharu

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking text cells between 2 worksheets	Malcolm	Excel Worksheet Functions	0	May 27th 10 10:47 PM
Linking text cells between 2 worksheets	FSt1	Excel Worksheet Functions	1	May 27th 10 09:50 PM
User Form Text Boxes - Copy format of text boxes	NDBC	Excel Discussion (Misc queries)	3	July 2nd 09 02:02 AM
Linking text boxes	Ranjan	Excel Discussion (Misc queries)	0	April 3rd 08 07:59 AM
How can I delete ALL text boxes in Excel worksheets?	Genesis	Excel Discussion (Misc queries)	3	January 20th 05 03:11 PM

Menu

About Us