How to integrate all VBA code in an optimized way and exist to ThisWorkbook?

Mr.MJ 1 Reputation point
2022-04-12T10:05:59.683+00:00

Hi,

I added the VBA code for each worksheet to allow multiple selections in a drop-down List, but it runs slowly and lags. Thus,

How to integrate all VBA code in an optimized way from each worksheet and exist to ThisWorkbook, and keep its basic function unchanged?

How to update to code to sort the selections according to the order of the drop-down menu in the cells?

How update the code to available to delete a part of selections (such as remove unwanted options) in a cell?

Example 1:
192321-1.png

Example 2:
192331-2.png

This is the file as reference:

https://1drv.ms/x/s!AibaAz5STOvFiCsPGAWn6Vnw48Po?e=tzfabV

Many thanks

J.

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
Developer technologies | Visual Basic for Applications
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.