none
ActiveX Textbox Control errors RRS feed

  • Question

  • I am trying to use the ActiveX Textbox Control in an Excel 2010 Worksheet. I have read the forum entries, tried different options. My TextBox name is correct. These are the options I have tried and the accompanying errors.

    If IsEmpty(Worksheets("SingleRecord").TextBoxes("boxComplete").Text) Then

    Error: Unable to get the TextBoxes property of the Worksheet class

    Worksheets("SingleRecord").Activate

     If IsEmpty(ActiveSheet("SingleRecord").TextBoxes("boxComplete").Text) Then

    Error: Object doesn’t support this property or method.

    If IsEmpty(ActiveSheet("SingleRecord").OLEObjects("boxComplete").Object.Text) Then

    Error: Object doesn’t support this property or method.

    Thanks

    Michael Morgan


    Michael Morgan



    • Edited by m3looper Monday, June 13, 2016 10:35 PM
    Monday, June 13, 2016 5:48 PM

Answers

All replies