Automation Error... maybe cause by Textbox in Userform

[Fahmieyz]

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.

I want to upload my file here but I don't see any button to upload.

Here is the external link to the file.

 

[Fahmieyz]

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.

I want to upload my file here but I don't see any button to upload.

Here is the external link to the file.

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.

 

[BlokeMan]

Cross-post;Automation Error... maybe cause by Textbox in Userform