Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox in userform
Master Bob,
Thank you for the tips. Just wonder what is "Cint" for -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add COUNTIF TO USERFORM TEXTBOX | Excel Worksheet Functions | |||
userform textbox | Excel Worksheet Functions | |||
Type of textbox on userform | Excel Programming | |||
How to add textbox/buttons to an UserForm | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |