Great god for help, want to use in the VBA code to add VALUE in the cell, run directly in the VBA code can be run normally, if in excel calls the function is not line, always show # VALUE! , the code to run to the CELLs (X, 4)="1" side is not running!

CodePudding user response:

Who help me!

CodePudding user response:

Function () Function, as a custom formula, is can't give other cell assignment, and you didn't even give Check1 gave in this Function value, so even if not the wrong, also don't know what will return,
So, you should be defined as a Sub () process, and need to run, to the Function () Function/custom formula, will change the way, return a value,

CodePudding user response:

Cells (x, 4). Value="https://bbs.csdn.net/topics/1"

CodePudding user response:

refer to the second floor zara's reply:

Function () Function, as a custom formula, is can't give other cell assignment, and you didn't even give Check1 gave in this Function value, so even if not the wrong, also don't know what will return,
So, you should be defined as a Sub () process, and need to run, to the Function () Function/custom formula, will change the way, return a value,

Sub how to call in excel?

CodePudding user response:

The

reference 3 floor echelonely response:

Cells (x, 4). The Value="https://bbs.csdn.net/topics/1"

add do not add Value

CodePudding user response:

Sub (), is through the "macro". "run" function to perform, quick can press Alt + & lt; F8 & gt;