Hello,
I.ve got a problem regarding a userform textbox, when i load the userform some values are loaded (see code)
Everything works fine untill the formula in cel D6 returns zero, then the textbox is empty istead of showing 0.
Please Login or Register to view this content.
Anyone an idea?
Change .Text to .Value
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
The code works fine for me if I comment out the second line where you put the value from D7 into TextBox2.
If posting code please use code tags, see here.
6StringJazzer,
Works like a charme, thanks.
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!Originally Posted by 6StringJazzer
In the code there are multiple textboxes refering to different cells.
The issue was only on one textboxes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks