Clear content of textbox in userform

G

Guest

Hello!

I would like to clear the content of single textboxes of my userform.

To clear all content I use a commandbutton which works fine. When I select a
specific textbox and press the delete key the textbox looks empty. Then I
click the button "save changes" using the code below but the change is not
saved to my table. When I change values the change will be saved to the table.

Private Sub cmd_save_Click ()
ActiveCell.Offset(0, 47) = CDbl(txt_fwdEUR)
ActiveCell.Offset(0, 48) = CDbl(txt_janEUR)
ActiveCell.Offset(0, 49) = CDbl(txt_febEUR)
ActiveCell.Offset(0, 50) = CDbl(txt_marEUR)
ActiveCell.Offset(0, 51) = CDbl(txt_aprEUR)
ActiveCell.Offset(0, 52) = CDbl(txt_mayEUR)
ActiveCell.Offset(0, 53) = CDbl(txt_junEUR)
ActiveCell.Offset(0, 54) = CDbl(txt_julEUR)
ActiveCell.Offset(0, 55) = CDbl(txt_augEUR)
ActiveCell.Offset(0, 56) = CDbl(txt_sepEUR)
ActiveCell.Offset(0, 57) = CDbl(txt_octEUR)
ActiveCell.Offset(0, 58) = CDbl(txt_novEUR)
ActiveCell.Offset(0, 59) = CDbl(txt_decEUR)
End Sub

How can I solve it?

Best regards,

Bodo Frost
 
G

Guest

cdbl("")

raises an error for me [type mismatch]. Perhaps you are suppressing the
error and don't realize it has occured (and prevented the update).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add the values of TextBoxes 2
Entering data from a userform into multiple sheets 2
Date showing as numbers in Textbox on Userform 2
Userform - validation data. Please help needed 2
Userform enter a field checking other two fields - Thank you 2
Userform enter a field checking other two in database 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
random dates showing up in userform 1

Top