LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default When data in TextBox2 matches data in TextBox1

Hi all,

I have developed a userform that when the user clicks the OK button, the
data entered is dumped onto Sheet2.

I would like for the data, once entered, that if the data into TextBox2 is
identical to the data entered into TextBox1, then all data should be dumped
onto Sheet1 instead.

What coding would I need to add to solve this problem.

Thanx in advance.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Matches Stacey Excel Discussion (Misc queries) 1 February 20th 07 02:24 PM
Vlookup 2 data matches? Nav Excel Discussion (Misc queries) 5 November 27th 05 04:18 PM
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) helmekki[_29_] Excel Programming 1 October 15th 04 04:15 AM
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) helmekki[_27_] Excel Programming 2 October 15th 04 12:32 AM
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) helmekki[_26_] Excel Programming 2 October 14th 04 05:23 AM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"