Automation Error... maybe cause by Textbox in Userform

F

Fahmieyz

New member
Joined
Sep 3, 2015
Messages
3
Reaction score
0
Points
0
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.

View attachment Automation Error.xlsm
 
I believe that should be

Me.TextBox110.Text = Sheets("RuleSetup").Range("P16").Value
 
Fahmieyz, I see you didn't bother to read the posting rules on numerous sites.

Would it bother you too much to at least acknowledge whether or not the above post rectified the situation?
It did on my computer, did it on yours?
 
NoS said:
Fahmieyz, I see you didn't bother to read the posting rules on numerous sites.

Would it bother you too much to at least acknowledge whether or not the above post rectified the situation?
It did on my computer, did it on yours?
Click to expand...

Sorry sir NoS,

I been busy. I have to do another coding for sorting and search function. Sorry for the late reply.

Just now I do the Me.TextBox110.Text = Sheets("RuleSetup").Range("P16").Value coding to my userform but it still on Automation Error. When you said 'It did on my computer' are referring to downloading my file and make the changes? If that the case maybe my computer may have problem with regedit
 
Interesting...

I did download your file, did what you indicated, saved, closed, reopened and clicked Edit Rule and it crashed big time to the extent of needing to reboot the computer.

Changed the instruction to include the me. part same save, close, reopen and was able to click Edit Rule and user form open.

This morning I open the same file click Edit Rule and get the crash again. Other than the computer having been totally shut down with power removed overnight everything's the same.... beats me what's happening.
 
NoS said:
Interesting...

I did download your file, did what you indicated, saved, closed, reopened and clicked Edit Rule and it crashed big time to the extent of needing to reboot the computer.

Changed the instruction to include the me. part same save, close, reopen and was able to click Edit Rule and user form open.

This morning I open the same file click Edit Rule and get the crash again. Other than the computer having been totally shut down with power removed overnight everything's the same.... beats me what's happening.
Click to expand...

Rebooting? Is my coding for some reason manage to change the registry of the computer? I pretty much lost on this part.
 
Try the attached and report back.
 

Attachments

  • ExcelGuru4864Automation Error.xlsm
    123.2 KB · Views: 37
I am having the same problem as described by Fahmieyz above -- using windows 10, excel2016. did someone ever find the solution?
 
You must log in or register to reply here.
Back
Top