In Excel I need a macro to tell me if the Text Box Number is Blank or has
Text in it.

Textboxes on the worksheet?

'if from the control toolbox toolbar
MsgBox Len(Worksheets("sheet1").TextBox1.Value)

'if from the Drawing toolbar
MsgBox Len(Worksheets("sheet1").TextBoxes("Text box 2").Text)

You could just look to see if it was equal to "", too.



Jerry Dyben wrote:

In Excel I need a macro to tell me if the Text Box Number is Blank or has
Text in it.

--

Dave Peterson