How to make OLE1 EXCEL table, in the third column content automatically fill in the content and the-CodePudding

That is to say, I am in VB call the EXCEL spreadsheet of OLE, I want to input the EXCEL spreadsheet content, when after input the content of the column 1 and column 2, the third column content automatically generated (after input the content of the column 2), because in fact my column 3 is the content of the column 1 and column 2 content multiplication

Also how will automatically fill the contents of the EXCEL spreadsheet to a text box in the VB (namely I think when the EXCEL form to fill in, after the completion of the third column data content and automatic fill out another text input box to VB)

CodePudding user response:

Ladies and gentlemen, we have good way?