Buttonclick add nothing to cell trough textbox

[Petter120]

Hi

I have seven textboxes thats connected to seven cells in a sheet (Range B6:H6)

If add a value to the first textbox lets say "5" and leave the rest of the textboxes blank ant press the commandbutton the result in the sheet will be:
B6 = 5,0
C6 = 0,0
D6 = 0,0
E6 = 0,0
G6 = 0,0
H6 = 0,0

Is it possible to get cells C6 to H6 to be blank instead of showing 0,0 when their textboxes are left blank ?

Please Login or Register  to view this content.

Petter

[alansidman]

Try a series of If then statements along this line

Please Login or Register  to view this content.

[Petter120]

Ok i am almost there sometimes i have values that is 0,1 or 0,9 and even 0,0.

Is there a way only ignore if the textbox is blank ?

I have tried this

Please Login or Register  to view this content.

and this

Please Login or Register  to view this content.

but it does not work.

// Petter

[alansidman]

Try this line instead

Please Login or Register  to view this content.

or perhaps

Please Login or Register  to view this content.