Zero value in userform textbox

**ABBOV** · 01-16-2013, 12:29 PM

Hello,

I.ve got a problem regarding a userform textbox, when i load the userform some values are loaded (see code)

Please Login or Register  to view this content.

Everything works fine untill the formula in cel D6 returns zero, then the textbox is empty istead of showing 0.

Anyone an idea?

**6StringJazzer** · 01-16-2013, 10:02 PM

Change .Text to .Value

**Norie** · 01-16-2013, 10:13 PM

The code works fine for me if I comment out the second line where you put the value from D7 into TextBox2.

**ABBOV** · 01-17-2013, 12:07 PM

6StringJazzer,

Works like a charme, thanks.

**6StringJazzer** · 01-17-2013, 02:16 PM

Well, now I'm confused because Norie noted a problem that could not possibly be fixed by my suggestion. Please note your first line of code has no effective because the second line writes a different value into the text box. Do you mean for this to be two different text boxes?

**ABBOV** · 01-17-2013, 07:12 PM

Originally Posted by 6StringJazzer

Well, now I'm confused because Norie noted a problem that could not possibly be fixed by my suggestion. Please note your first line of code has no effective because the second line writes a different value into the text box. Do you mean for this to be two different text boxes?

My bad, "copy pasted" en did not change it correctly!
In the code there are multiple textboxes refering to different cells.

The issue was only on one textboxes.