error

A

Alvin Hansen

Hi
I have this in a userform

If CDbl(TextBox17.Value) > 0 Then
sum
End If
Its working all right but if i go back and maybe will change the value in
this box
and delete all then i get a error, how can i make it so i don't get thsi
error if
i delete the value and will write a new one in the textbox

Regards

Alvin
 
F

Frank Kabel

Hi
you may post the complete code. Not really sure what you're meaning
with 'go back and delete'
 
A

Alvin Hansen

I have found out what i can do
i use
Private Sub TextBox23_Change()
If IsNumeric(TextBox23.Value) Then
chk8
End If
End Sub
Then is dosn't make a error in my sub chk8
But maybe you can help me with this

I use formatnumber and its working allright
but i have som textbox where i in my userform can
write a value fe.ks. 100 can't i use formatnumber also in this cells
so when i write the number its from the start format the cell
to 100,00

Best regards alvin





"Frank Kabel" skrev:
 
Top