Macro to add / create a new sheet in an excel file and rename sheet using Inputbox option in VBA.
Macro to add / create a new sheet in an excel file and rename sheet using Inputbox option in VBA.
Steps to follow to load and run Macro
Step 1). Open an excel file
Step 2). Press Alt + f11 for windows users and Option + F11 for MacOS users
Step 3). Create a new module by right clicking tab name insert and then module
Step 4). Paste the following code in the module, then save and close
Step 5). Click on view and then run macros "add_sheet
Sub add_sheet()
Dim x As String
Worksheets.Add
x = InputBox("Enter the sheet name")
ActiveSheet.name = x
End Sub
Link of My Videos
How to create a password protected excel file
• How to create password protected exce...
Create your first Macro in Excel VBA
• My First Excel VBA Macro program. How...
How to use IFERROR Function with Vlookup Function
• IFERROR with Vlookup function is used...
Use of Hlookup Function
• Use of HLOOKUP FUNCTION - HLOOKUP FUN...
Use of Vlookup Function
• VLOOKUP FUNCTION - Use VLOOKUP when y...
Use of Lookup Function
• LOOKUP FUNCTION -A value that LOOKUP ...
Create multiple files from a single file based on a criteria using macros in excel VBA
• Use of Macro to Un-merge / Split data...
MID Function - Extract number / words from a dynamic position / position not fixed
• MID Function - Extract number / words...
Change date format using Text Function
• Change date format using Text Function
How to protect rows or columns - Allow edit range allows you to edit only selected ranges in Excel
• How to protect rows or columns - All...
Concatenate function used with text function, joins two or more text / numbers into one
• Concatenate function used with text f...
Text Function - change the way a number /text / date appears
• Text Function - change the way a numb...
How to use Subtotal function to count visible cells only in a given range
• How to use Subtotal function to count...
Use of Subtotal function to sum / total of all visible cell in a given range
• Use of Subtotal function to sum / tot...
Use of Dollar Sign/ How to use $ Sign, Freeze rows or column and both
• Use of Dollar Sign/ How to use $ Sign...
How to console / Merge multiple text files into one text file using command prompt / DOS / CMD
• How to console / Merge multiple text ...
How to use SUMIFS function, sums a selected range with multiple criteria's / conditions
• How to use SUMIFS function, sums a se...
How to create aging / Bucketing using IF Function in excel
• How to create aging / Bucketing using...
SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
• How to use SUMIFS function, sums a se...
How to create aging / Bucketing using IF Function in excel
• How to create aging / Bucketing using...
SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
• SUMIF Function - Sumif function, sums...
Use of Countif Function - How to count cells in a range with a condition / Criteria
• Use of Countif Function - How to cou...
Use of CountBlank Function - Count empty cells in a given range in Excel
• Use of CountBlank Function - Count em...
Use of CountA Function- CountA function use and comparison/Difference of CountA with Count function
• Use of CountA Function- CountA functi...
Count Function - How to count numeric value in MS Excel using Count Function
• Count Function - How to count numeric...