One Macros for Many Sheets

[cyliyu]

I have two buttons in both sAAA and skAAA sheets that execute 2 different macros (search and check)
I am trying to keep these macros in the module with only 1 each so that whenever I added more sheets, e.g. sBBB and skBBB, sCCC and skCCC and so on, I do not need to duplicate the 2 macros for all sheets.

How can I make the code automatic to select the sheet which I am viewing and execute the macros?
I have attached the sample file for reference. Thanks.
Below one of the code from the sample file.

Please Login or Register  to view this content.

[davesexcel]

The sheet you are viewing is the activesheet.

[cyliyu]

Thanks. Will check and give it a try.

[cyliyu]

Hello,
I managed solve the code.
But, I need some advise to improve my IF statement.
The sample came with only 4 sheets (AAA & BBB 2 each).
If more sheets to be addon, how can I improve the code? Thanks.

Please Login or Register  to view this content.

[maniacb]

Here is an approach.

Please Login or Register  to view this content.

[cyliyu]

Thanks, Maniacb.

The statement restricted to 3 char.
If a sheet name is more then 3, it will not work.
Is it possble to have it flexible too?

Please Login or Register  to view this content.

[maniacb]

I thought that might be a problem, but don't know relationship between skBBB and BBB. Try this

Please Login or Register  to view this content.

[cyliyu]

Thanks for the guidance & hints.

I make changes to the code.
The workbook stored many products and AAA repersent product A where c (cXXX) refer to a chart and s (sXXX) for serach etc.

Please Login or Register  to view this content.