Userform Textbox with figures

[Doflamingo]

Hi all,

I have a userform with some textboxs that are linked to some cells in a sheet of Excel.

Here is the code of the userform

Private Sub UserForm_Initialize()
TextBox1.Value = ""
TextBox2.Value = ""
TextBox3.Value = ""
TextBox4.Value = ""

end sub

And here is the code of the command button which is supposed to put in some specific cells of Excel, the values of the figures put in the textboxes

Private Sub CommandButton1_Click()
Sheet1.Activate
Range("B4") = TextBox1.Value = ""
Range("c4") = TextBox2.Value = ""
Range("d4") = TextBox3.Value = ""
Range("e4") = TextBox4.Value = ""


End Sub

But that's weird, because when I enter the values of figures in the different textboxes and then click on the commandbutton, I see in ranges b4, c4, d4, e4 : FALSE

Any ideas ?

I would rather like to see the figures entered in the textboxes.

Many thanks in advance

 

[Fluff]

Remove this part

= ""

from all those lines

 

[Doflamingo]

Thank you Fluff, works perfectly, I would outline that point: remove ="" only for the commandbutton but nor for the userform.

Thanks again!!

Have a good day

 

[My Aswer Is This]

If you unload the Userform when you close it all those Textboxes are cleared automatically.

Close UserForm like this:

Unload Me

 

[Fluff]

You're welcome & thanks for the feedback