| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick English to VBA
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick English to VBA
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick English to VBA
oh ok, now I get it. Sorry i had to ask you twice. Thanks a lot!!!! -- Trintrin ------------------------------------------------------------------------ Trintrin's Profile: http://www.excelforum.com/member.php...o&userid=32681 View this thread: http://www.excelforum.com/showthread...hreadid=526824 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quick charting question for similar charts on multiple sheets | Charts and Charting in Excel | |||
| How to translate excel function names from english to local langua | Excel Worksheet Functions | |||
| Conversion of a Number into English Text | Excel Worksheet Functions | |||
| Using Excel converts number to english text | Excel Worksheet Functions | |||
| quick books and excel 2002 | New Users to Excel | |||
Linear Mode
