I was a novice, just learn to do a piece of text box variable code, but after finished commissioning prompt real-time error "1004"
Object "RANGE" method "_Worksheet" failure; Don't know where is wrong, now I each prawn to help me to check and improve the code, thank you first! I compiled code is as follows:

Dim format As A Single, format As Single B

Format A=Val (Text1. Text)

The format B=Val (Text2. Text)

Format xlSheet. Range (" A: B "). The NumberFormatLocal="@"

CodePudding user response:

Need to refer to Excel object, statement of the corresponding variable, open the file, and a series of operations, to the object,