Hi.
I have 5 textbox.
The (file) code below only works when the 3 textbox are filled with values.
case is filled to textbox1 and textbox2, and the TextBox3 went blank, generates an error message.
case is completed and the textbox2 TextBox3, and the textbox1 went blank, generates an error message.
anyone know why this happens?
thank you!
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
After taking a quick peek at the file it looks like your functions are referencing the textboxes but not error checking to determine if there is a blank value. You might try defaulting the textboxes to some value (say, 0), or doing a quick check to determine if the textbox has a valid value prior to using that value in a calculation.
VBA can't add blank cells.
It maybe just as easy to set the textboxes to equal zero if they are blank, for example:
Please Login or Register to view this content.
Hi.
Very good!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks