software

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: www.excelforum.com/member.php...oamp;userid=32681
View this thread: www.excelforum.com/showthread...hreadid=526824Try something like

If Me.TextBox1.Text lt;gt; quot;quot; Then
ws.Cells(iRow,1).Value = Me.TextBox1.Text
End If--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Trintrinquot;
gt; wrote in
message
...
gt;
gt; Please help me translate this code
gt; to VBA!
gt;
gt; if textbox1 = nothing (as in no information) Then do not write
gt; anything
gt; or erase anything
gt;
gt; if textbox1 = anything THEN write anything in given cell
gt; ie. -ws.Cells(iRow, 1).Value = Me.textbox1.Value-
gt;
gt;
gt; --
gt; Trintrin
gt; ------------------------------------------------------------------------
gt; Trintrin's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32681
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=526824
gt;

oh ok, now I get it.

Sorry i had to ask you twice. Thanks a lot!!!!--
Trintrin
------------------------------------------------------------------------
Trintrin's Profile: www.excelforum.com/member.php...oamp;userid=32681
View this thread: www.excelforum.com/showthread...hreadid=526824