close

Is there a way to make two fields in form (may be option buttons or text
box fields) to be mirror of each other without doing any coding.

For eg:

There are text boxes: T1 amp; T2
Both of them are empty initially.
Now I change the value of T1 to quot;Jatzquot;. Then T2 should get updated to
quot;Jatzquot;.

No I add quot;kalsquot; to T2 so that the value of T2 becomes quot;Jatz Kalsquot;. Now
at this point the value of T1 should also become quot;Jatz Kalsquot;

I am looking for an easier way so that T1 amp; T2 should always have the
same value without doing any coding.

Thanks in Advance.

Regards,

Jatz Kals--
JAtz_DA_WAY
------------------------------------------------------------------------
JAtz_DA_WAY's Profile: www.excelforum.com/member.php...oamp;userid=26684
View this thread: www.excelforum.com/showthread...hreadid=504120These are two textboxes on a userform?

If yes, then assign the same cell to the .controlsource for each textbox.
JAtz_DA_WAY wrote:
gt;
gt; Is there a way to make two fields in form (may be option buttons or text
gt; box fields) to be mirror of each other without doing any coding.
gt;
gt; For eg:
gt;
gt; There are text boxes: T1 amp; T2
gt; Both of them are empty initially.
gt; Now I change the value of T1 to quot;Jatzquot;. Then T2 should get updated to
gt; quot;Jatzquot;.
gt;
gt; No I add quot;kalsquot; to T2 so that the value of T2 becomes quot;Jatz Kalsquot;. Now
gt; at this point the value of T1 should also become quot;Jatz Kalsquot;
gt;
gt; I am looking for an easier way so that T1 amp; T2 should always have the
gt; same value without doing any coding.
gt;
gt; Thanks in Advance.
gt;
gt; Regards,
gt;
gt; Jatz Kals
gt;
gt; --
gt; JAtz_DA_WAY
gt; ------------------------------------------------------------------------
gt; JAtz_DA_WAY's Profile: www.excelforum.com/member.php...oamp;userid=26684
gt; View this thread: www.excelforum.com/showthread...hreadid=504120

--

Dave Peterson


Thanks Dave for replying so fast.

BUT, i am sorry .... its not a userform..

I am using these contols in the Word file. The text box amp; all other
controls do not have .controlsource feature.

thanks in advance

Regards,

Jatz--
JAtz_DA_WAY
------------------------------------------------------------------------
JAtz_DA_WAY's Profile: www.excelforum.com/member.php...oamp;userid=26684
View this thread: www.excelforum.com/showthread...hreadid=504120MSWord?

I bet you'll get better results in one of the MSWord newsgroups.

JAtz_DA_WAY wrote:
gt;
gt; Thanks Dave for replying so fast.
gt;
gt; BUT, i am sorry .... its not a userform..
gt;
gt; I am using these contols in the Word file. The text box amp; all other
gt; controls do not have .controlsource feature.
gt;
gt; thanks in advance
gt;
gt; Regards,
gt;
gt; Jatz
gt;
gt; --
gt; JAtz_DA_WAY
gt; ------------------------------------------------------------------------
gt; JAtz_DA_WAY's Profile: www.excelforum.com/member.php...oamp;userid=26684
gt; View this thread: www.excelforum.com/showthread...hreadid=504120

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()