Pure new subject made a VBA
Input function to do want to do a search function from a sheet1 page data retrieval results reflect to another sheet2 page
(intermediate file can reference but didn't find where to add attachments)
Wish you a great god guide to help

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

reference 1st floor zhao4zhong1 response:

began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

Four elder brother Alt + F11 directly write code that needs to be a for loop know how to write, please ask for help,,

CodePudding user response:

refer to the second floor qq_38608334 response:

Quote: refer to 1st floor zhao4zhong1 response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

Four elder brother Alt + F11 directly write code that needs to be a for loop know how to write, please ask for help,,

You consider me a few years ago in baidu know to others reply method,

I that is the search results in the ListBox, you have to do is to record in the Sheet2,


https://zhidao.baidu.com/question/568833010