I am a novice, is learning vba,
For example: I want to get table, called "Sheet1" read starting line 2,
Column names as follows: a, b, c, d, e, f, g, I listed below all data lines

CodePudding user response:

Problem description is not clear!
Read data from sheet1, read?

CodePudding user response:

Data read VBA window corresponds to the column

CodePudding user response:

Began keeping records in Excel macro, manual complete the required functions, such as you want to obtain the data is copied to the clipboard, the end of the record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

For example:
Data read text box with combobox
&
With the corresponding LIstbox column

CodePudding user response:

reference zhao4zhong1 reply: 3/f

began keeping records in Excel macro, manual complete the required functions, such as you want to obtain the data is copied to the clipboard, the end of the record macros, press Alt + F11 key, check just record macro corresponding VBA code,

add you WeChat?

CodePudding user response:

God knows how your VBA window with the worksheet "corresponding"...

CodePudding user response:

reference 5 floor vipasfe reply:

Quote: refer to the third floor zhao4zhong1 response:

Began keeping records in Excel macro, manual complete the required functions, such as you want to get the data is copied to the clipboard, the end of the record macros, press Alt + F11 key, check just record macro corresponding VBA code,

add you WeChat?

Began keeping records in Excel macro, manual complete the required functions, such as you want to get the data is copied to the clipboard, and paste it to the place you want to save, the end of the record macros, press Alt + F11 key, check just record macro corresponding VBA code,