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"
<Trintrin.25ccoj_1143484597.2288@excelforum-nospam.com> wrote in
message
news:Trintrin.25ccoj_1143484597.2288@excelforum-nospam.com...
>
> 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-
>
>
> --
> Trintrin
> ------------------------------------------------------------------------
> Trintrin's Profile:
> http://www.excelforum.com/member.php...o&userid=32681
> View this thread:
> http://www.excelforum.com/showthread...hreadid=526824
>

[Trintrin]

oh ok, now I get it.

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