Quick English to VBA

[Trintrin]

Please help me translate this code
to VBA!

if textbox1 = nothing (as in no information) Then do not write anything
or erase anything

if textbox1 = anything THEN write anything in given cell
ie. -ws.Cells(iRow, 1).Value = Me.textbox1.Value-

 

[Chip Pearson]

Try something like

If Me.TextBox1.Text <> "" Then
ws.Cells(iRow,1).Value = Me.TextBox1.Text
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Trintrin"
message
news:[email protected]...

 

[Trintrin]

oh ok, now I get it.

Sorry i had to ask you twice. Thanks a lot!!!!