Excel VBA and MACROS : HOW TO NAME PROCEDURES | RULES TO NAME PROCEDURES | CLASS 8

Опубликовано: 10 Октябрь 2024
на канале: Techdreamer

NSINTELLECT
NAWAZ SHAIKH

PROCEDURES | SUB AND FUNCTION PROCEDURES:    • Excel VBA and MACROS : PROCEDURES | S...

How to name procedure in VBA?
Things to consider before naming procedure in VBA?
Rules to name Procedure in VBA?

Things are as follows.

1.You can use letters, numbers, and some punctuation characters, but the first character must be a letter.
2.You can’t use any spaces or periods in the name.
3.VBA does not distinguish between uppercase and lowercase letters.
4.You can’t use any of the following characters in a procedure name: #, $, %, &, @, ^, *, or !. In other words, your procedure name can’t look like comic-strip curse words.
5.If you write a Function procedure for use in a formula, avoid using a name that looks like a cell address (for example, A1 or B52). Actually, Excel allows such function names, but why make things more confusing than they are already?
5.Procedure names can be no longer than 255 characters. (Of course, you would never make a procedure name this long.)

----------------------------------------------------------------------------------------------------------
Channel Link:
   / @techdreamerdotin
----------------------------------------------------------------------------------------------------------
Excel Series Link:
   • EXCEL
----------------------------------------------------------------------------------------------------------
Excel Tips And Tricks Link:
   • EXCEL TIPS AND TRICKS
----------------------------------------------------------------------------------------------------------
Excel VBA MACROS Link:
https://www.youtube.com/playlist?list... is the most frequent ask question of the interview for excel test.
----------------------------------------------------------------------------------------------------------
MIC Used .
https://amzn.to/36KjKOJ

#VBA #ExcelVBA #VBAforbegginer