If Cint(TextBox1.Text) = Cint(TextBox2.Text) + _
Cint(TextBox3.Text) + _
Cint(TextBox4.Text) + _
Cint(TextBox5.Text)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"shaharul " wrote in message
...
My problem is

Say i have 5 textbox consisting number value in user form
1 is master textbox and the other four are the breakdown of the master
How do i automatically check that total of the value of the other four
tsxtbox equal to value in master textbox.
How do i change the variant type of the value entered in textbox to
integer type?

Thank you in advance for all the Excel Master out there.


---
Message posted from http://www.ExcelForum.com/