In Excel I need a macro to tell me if the Text Box Number is Blank or has Text in it.
J Jerry Dyben Sep 27, 2005 #1 In Excel I need a macro to tell me if the Text Box Number is Blank or has Text in it.
D Dave Peterson Sep 28, 2005 #2 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.
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.
