help please
 

Hi,

I need to input two numbers into two different text boxes and then b
able to swap the 1st number with the second. I am not quite sure ho
to do this. Any ideas?

Thanks,

SEV

--
sevep2
-----------------------------------------------------------------------
sevep23's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26793

help please
 

Private Sub CommandButton1_Click()
Dim str As String

str = TextBox1.Text
TextBox1.Text = TextBox2.Text
TextBox2.Text = str
End Sub


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"sevep23" wrote in message
...

Hi,

I need to input two numbers into two different text boxes and then be
able to swap the 1st number with the second. I am not quite sure how
to do this. Any ideas?

Thanks,

SEVE


--
sevep23
------------------------------------------------------------------------
sevep23's Profile:
http://www.excelforum.com/member.php...o&userid=15158
View this thread: http://www.excelforum.com/showthread...hreadid=267930