+ Reply to Thread
Results 1 to 2 of 2

Automation Error... maybe cause by Textbox in Userform

  1. #1
    Registered User
    Join Date
    09-02-2015
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    1

    Automation Error... maybe cause by Textbox in Userform

    Hi,

    I have this problem with my vba coding, where I have this Automation Error when I execute my Userform.

    After trying to figure the cause of the problem, it seem when I try to push some value in cells into the some textbox this Automation Error occurs when executing.

    What is the problem? I use the same code format to push value in cells in another textbox but it working fine.

    Even when I make a new textbox this problem didn't solve.

    This problem only occurs when you put new textbox in the Tab 'Interval Inspection' and make a code TextBox110.Text = Sheets("RuleSetup").Range("P16").Value to push the value from Cells P16 into the text box. Click the button 'Edit Rule', close the userform and save the excel file. The next time you open the excel file and click the button 'Edit Rule', Automation Error will occurs.

    I uploaded the file.

    Automation Error.xlsm
    Last edited by Fahmieyz; 09-03-2015 at 12:07 AM.

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    349

    Re: Automation Error... maybe cause by Textbox in Userform

    Cross-post;http://www.mrexcel.com/forum/excel-q...-userform.html
    Please click the * Add Reputation if this helps
    If solved remember to mark Thread as solved

    "I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel Userform - keep focus on textbox after error
    By OM1950 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2015, 07:20 PM
  2. [SOLVED] Userform Textbox calculations divide by zero error
    By Code Flunkie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2014, 11:15 AM
  3. Error Message When Textbox in Userform Left Blank
    By zaclim78 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-07-2012, 12:19 PM
  4. [SOLVED] Run Time error 91 while updating texts in textbox in userform
    By Cijo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-25-2012, 09:08 AM
  5. Userform Error Check and Textbox Help
    By Impartial Derivative in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-06-2011, 10:20 AM
  6. userform textbox error trapping
    By runTNT in forum Excel General
    Replies: 2
    Last Post: 04-01-2011, 12:16 PM
  7. textbox automation error
    By John Wilson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1