Textbox in userform
 

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 fou
tsxtbox equal to value in master textbox.
How do i change the variant type of the value entered in textbox t
integer type?

Thank you in advance for all the Excel Master out there

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

Textbox in userform
 

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/

Textbox in userform
 

Master Bob,

Thank you for the tips. Just wonder what is "Cint" for

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

Textbox in userform
 

I think you posted to the wrong conversation.

--
Jim Rech
Excel MVP
"shaharul " wrote in message
...
| Master Bob,
|
| Thank you for the tips. Just wonder what is "Cint" for?
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|