In VB to read 'student id' this column and copy, and then a button on the interface 'copy the next student id, click copy the next student id,

CodePudding user response:

Screenshot attached form

CodePudding user response:

 ActiveCell. Offset (1, 0). Select 
Selection. Copy 

CodePudding user response:

Need to do this in the excel, or in VB to complete this operation?

CodePudding user response:

I prefer to use ado to access database engine will Excel as external database,