Class group of Textboxes

Hello everyone.
I have a problem with the class group i made...
imagine: i have 5 textboxes grouped

class module()

textboxgroup_change()
textbox1=textbox2 + textbox3
textbox4=textbox1 * 0.5

What is the problem you get?

--
HTH

Bob Phillips

"Liedson31" <[email protected]> wrote in message
news:[email protected]...
> Hello everyone.
> I have a problem with the class group i made...
> imagine: i have 5 textboxes grouped
>
> class module()
>
> textboxgroup_change()
> textbox1=textbox2 + textbox3
> textbox4=textbox1 * 0.5
>

sorry for that, i press enter key without finish the question.....
the problem is.
with the change event the function loops over and over because the textboxes
are assuming calculated values....

so with the keydown(i must validate the data inserted-only numbers) code
that i already use i must call a function named Calculate_Values, and in this
function i piut all the formulas i must have:textbox1=textbox2 +
textbox3,.......

the problem is with the keydown(the one that solves my problem) if want to
get the value in the textbox(imagine textbox1 had the value 10 if i want to
change it to 100) i only get 10 with textbox1.text....so when i do the
calculations the function don´t get the value 100 from textbox1....

any ideas for this
thanks very much
Miguel



"Bob Phillips" wrote:

> What is the problem you get?
>
> --
> HTH
>
> Bob Phillips
>
> "Liedson31" <[email protected]> wrote in message
> news:[email protected]...
> > Hello everyone.
> > I have a problem with the class group i made...
> > imagine: i have 5 textboxes grouped
> >
> > class module()
> >
> > textboxgroup_change()
> > textbox1=textbox2 + textbox3
> > textbox4=textbox1 * 0.5
> >
>
>
>

.... i forgot... when i talk textbox1.text,in fact its
me.textboxgroup.text...i think it want change the solution but.......

"Liedson31" wrote:

> sorry for that, i press enter key without finish the question.....
> the problem is.
> with the change event the function loops over and over because the textboxes
> are assuming calculated values....
>
> so with the keydown(i must validate the data inserted-only numbers) code
> that i already use i must call a function named Calculate_Values, and in this
> function i piut all the formulas i must have:textbox1=textbox2 +
> textbox3,.......
>
> the problem is with the keydown(the one that solves my problem) if want to
> get the value in the textbox(imagine textbox1 had the value 10 if i want to
> change it to 100) i only get 10 with textbox1.text....so when i do the
> calculations the function don´t get the value 100 from textbox1....
>
> any ideas for this
> thanks very much
> Miguel
>
>
>
> "Bob Phillips" wrote:
>
> > What is the problem you get?
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Liedson31" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello everyone.
> > > I have a problem with the class group i made...
> > > imagine: i have 5 textboxes grouped
> > >
> > > class module()
> > >
> > > textboxgroup_change()
> > > textbox1=textbox2 + textbox3
> > > textbox4=textbox1 * 0.5
> > >
> >
> >
> >

i use the key_up procedure...it seems to me that solves the problem,i put a
flag and when the keydown procedure returns the flag=true in the key_up
procedure runs the function Calculate_Values.....

is this the right way to do it......

"Liedson31" wrote:

> ... i forgot... when i talk textbox1.text,in fact its
> me.textboxgroup.text...i think it want change the solution but.......
>
> "Liedson31" wrote:
>
> > sorry for that, i press enter key without finish the question.....
> > the problem is.
> > with the change event the function loops over and over because the textboxes
> > are assuming calculated values....
> >
> > so with the keydown(i must validate the data inserted-only numbers) code
> > that i already use i must call a function named Calculate_Values, and in this
> > function i piut all the formulas i must have:textbox1=textbox2 +
> > textbox3,.......
> >
> > the problem is with the keydown(the one that solves my problem) if want to
> > get the value in the textbox(imagine textbox1 had the value 10 if i want to
> > change it to 100) i only get 10 with textbox1.text....so when i do the
> > calculations the function don´t get the value 100 from textbox1....
> >
> > any ideas for this
> > thanks very much
> > Miguel
> >
> >
> >
> > "Bob Phillips" wrote:
> >
> > > What is the problem you get?
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > "Liedson31" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Hello everyone.
> > > > I have a problem with the class group i made...
> > > > imagine: i have 5 textboxes grouped
> > > >
> > > > class module()
> > > >
> > > > textboxgroup_change()
> > > > textbox1=textbox2 + textbox3
> > > > textbox4=textbox1 * 0.5
> > > >
> > >
> > >
> > >