Note: You cannot use the Me keyword inside of a regular module!Īny code that is put into a worksheet module is specific to that worksheet putting code into the workbook, via ThisWorkbook, is specific to the workbook in which it is placed and putting Me inside the code for a UserForm refers to that UserForm. You can use the Me keyword inside of a worksheet module, a workbook module, and a UserForm. This allows you to make more versatile macros that won't break when you rename something or copy them to another workbook or worksheet. The Me keyword in Excel VBA allows you to refer to either the current worksheet, workbook, or userform without having to use their name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |