Occur because the machine does not have a clear former PMC do a production management using VB to do right now to replace a system result in an error can have a great god remote assistance

CodePudding user response:

This kind of situation is probably has a text box control in the sheet1, its name is "number", this control is missing, you add a text box control, name changed to "number"

CodePudding user response:

reference 1st floor xyxcc177109 response:

this kind of situation is probably has a text box control in the sheet1, its name is "number", this control is missing, you add a text box control, name changed to "number"

The forehead is a small white won't do it I can help it

CodePudding user response:

Reduce the security level of Excel, allowing all macros,

CodePudding user response:

reference zhao4zhong1 reply: 3/f

reduce the security level of Excel, allowing all macros,

Use the same error

CodePudding user response:

Looking for former boss and former I ask,

CodePudding user response:

Have a look "number" is the name of the control, as shown in figure

CodePudding user response:

You excel thin isn't there a name for the number of work table you change the code inside the number to your current work table name

CodePudding user response:

refer to 7th floor pugai888 response:

you excel thin isn't there a name for the number of work table you change the code inside the number to your current work table name

You take a closer look at the building code:
Sheet1. Number. Valuehttps://bbs.csdn.net/topics/=""
When executed, is "number" didn't find,
The Sheet1 is "worksheet", "number" how could still "worksheet"!
As the sixth floor, should be missing a "control name" in the worksheet Sheet1 is "number" of the text box control that this possibility is big!

CodePudding user response:

My KAO!!!!!!
7th floor, you are so carefree get boring ah, why dig grave!!!!!!

CodePudding user response:

I felt as if seen someone ask this

CodePudding user response:

references 9 f Chen8013 response:

my KAO!!!!!!
7th floor, you are so carefree get boring ah, why dig grave!!!!!!

Not bad people dig grave, lai CSDN server clock breakdown, instantly by gamma ray