Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello:
I'm trying to do some simple math using the values in some textboxes, and I'm getting an error on this statement: Controls("TextBox" & (Y + 2)).Value = Round((Controls("TextBox" & _ (Y + 1)).Value / 100 * WORSTKG), 0) The right side of the equation takes a value from a textbox, divides it by 100, multiples it by another variable (WORSTKG - which is a numeric value from another textbox) and then rounds it off to a whole number and puts the answer into a third textbox. It's part of a loop which is why the textbox name contains a variable suffix. At least that's the plan, but I'm getting a "type mismatch" error. LATE NOTE: should it make a difference if I set the Controls("TextBox" & (Y + 1)).Value expression equal to a variable before doing the math (the way I did WORSTKG?)? If so, why would it? Help would be appreciated. Thanks, MARTY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Easy One - Syntax for variables in TextBox & Label names | Excel Programming | |||
How do I add TextBox.values? | Excel Discussion (Misc queries) | |||
How do I add TextBox.values? | Excel Worksheet Functions | |||
Clearing Form Values the easy Way??? | Excel Programming | |||
easy question : textbox | Excel Programming |