autofill textbox based on other textbox entry

[TimvanSprang]

I think the solution is rather simple, I just can't find it.

I have textboxes 102, 103, 104, 105, 106

I want the values in 103-106 to be autofilled based on values in 102. I wrote the following code.

Private Sub TextBox102_change()
TextBox103.Value = TextBox102.Value * 3.125
TextBox104.Value = TextBox103.Value * 2
TextBox105.Value = TextBox102.Value * 0.2
TextBox106.Value = TextBox104.Value * 2

This works perfectly untill I use backspace in textbox102. as soon as the value in textbox 102 is removed an error occurs.

error 13
type doesn't mach (or something like that, I had to translate from dutch)

Can someone help me fix this problem?

Thanks a lot

 

[ji32m]

Have you tried assigning the values to variables first, as intermediate steps, before those in turn are assigned to the respective boxes?

 

[TimvanSprang]

No, how would that work?

 

[ji32m]

sTB103 = TextBox102.Value * 3.125: TextBox103.Value = sTB103
sTB104 =TextBox103.Value * 2: TextBox104.Value = sTB104
sTB105 = TextBox102.Value * 0.2: TextBox105.Value = sTB105
sTB106 = TextBox104.Value * 2: TextBox106.Value = sTB106

 

[TimvanSprang]

Nope,

that doesn't work. The problem I think is caused by the formula's. At the beginning there is nothing in textbox 103. But as soon as I change textbox102 textbox103 startscalculating and causes an error when textbox102 is emptyd. But I can;t figure out how to fix it.

 

[ji32m]

Try connecting each TextBox to its own individual spreadsheet cell, then operate on the latter. Refresh if necessary.