<div>
Darren,<br />
<br />
Can you be more specific about the process, what event will &quot;trigger&quot; the check?<br />
<br />
Thanks<br />
Dave
</div>


<div>
Sorry when the excel sheet is opened
</div>


<div>
Guys<br />
<br />
Thanks for the code I have just tried Chris's and they all work as desired<br />
<br />
Thanks I will split points<br />
<br />
Thankyou
</div>


<div>
<div class="content wysiwyg-content">
Guys<br />
<br />
I need an example of a vb script for excel 2003 that checks a textbox to see if it is blank if it is it then prompts you to enter a value in the text box but if there is a value there then do nothing<br />
<br />
Any ideas<br />
<br />
Regards
</div>
</div>


Guys

I need an example of a vb script for excel 2003 that checks a textbox to see if it is blank if it is it then prompts you to enter a value in the text box but if there is a value there then do nothing

Any ideas

Regards

Darren,

Can you be more specific about the process, what event will &quot;trigger&quot; the check?

Thanks
Dave

Guys

Thanks for the code I have just tried Chris&#39;s and they all work as desired

Thanks I will split points

Thankyou

VB Script to check if textbox is blank

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.