Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Excel VBA Macro Worksheet

VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets

March 19, 2023
Kumarapush

Learn VBA to unhide all sheets in a Excel workbook. This code sets visibility property of sheet to unhide even the very hidden sheets.

Excel Keyboard Shortcut VB6

VBA Userform – Escape key to Close – Unload form

March 19, 2023
Kumarapush

Learn how to close a vba userform with escape key. Map command button to Exit or Close a Userform with Escape key.

MS Word VBA Beginners

VBA to open or save Word document Protected or Encrypted with password

March 19, 2023
Kumarapush

Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.

Excel VBA Macro

VBA Get Numbers with in a String

March 19, 2023
Kumarapush

Excel VBA code to get all digits or numbers with a string. This function extract only the numbers from with in a string text.

Android Browser

New Android Update – View/Send SMS messages from any PC Web browser

March 19, 2023
Kumarapush

Send View SMS messages from PC web browsers like Chrome Edge Safari Firefox for Android smartphones

Whatsapp Android

Send WhatsApp without Saving Number in Contact

March 19, 2023
Kumarapush

Use this option to send Whatsapp without saving number in your phone contacts. Use web url to send direct message to number without adding in contacts

Calendar

2022 Holiday List – India Vacation Planner

March 19, 2023
Kumarapush

2022 Holiday list for india with vacation planner details that would help you get the long vacation details along with other national holidays.

Calendar

List of Holidays 2022 – USA Vacation Planner

March 19, 2023
Kumarapush

Get the list of holidays 2022 aong with dates, days & also which one are coming up in long weekends. Plan vacation with this holiday list 2022

Outlook Macro

How to remove Signature from Outlook Email using VBA code?

March 19, 2023
Kumarapush

Get the Outlook vba code to remove the signature from a email that was autoamtically created within the macro. It is usefull when you add custom signature.

VBA Array Excel Excel VBA Macro

VBA – Find number of Dimensions in an Array

March 19, 2023
Kumarapush

How to find the dimensions in an array using Excel vba code? Here is the code to cound the array dimensions using the ubound function – tricky one.

Posts navigation

Previous 1 2 3 … 39 Next
VBA Array Tricks
  • Excel VBA – Convert Range To Array – 2 Dimentional
  • VBA Array Initialize Values – Split string to array
  • VBA – Add Items to Array – Dynamic Resize without erasing data
  • Excel Vba Sort Array – Quick Trick using built in function
  • VBA – Create Array from Excel Range – 1 Dimension
Excel VBA Macro Tricks
  • Validate Email Address – VBA Code – Excel
  • Vba Check if Sheet Exists – If not Create
  • Add Excel VBA Drop Down Data Validation List
  • Hide Unhide Worksheet Tabs in Excel
  • Password Protect Excel 2010 & 2007
Worksheet Tricks
  • Rearrange Excel Sheets in Custom or Alphabetic Order with VBA
  • Hide Unhide Worksheet Tabs in Excel
  • Vba Check if Sheet Exists – If not Create
  • How to Add Sheets in Excel – VBA Create Worksheet – Dynamic Spreadsheet
  • Sort Listview Column on Click – VBA/VB6 Userform
  • Bulk Excel VBA Send Email with Attachments – 2 Multiple recipients
  • GB Whatsapp Features – Easy Download Steps
  • Excel VBA For each cell in Range – Direct method
  • Excel VBA Send Email at Specific Time – Outlook Delayed Delivery
  • Sort Listview Column on Click – VBA/VB6 Userform
    Get VBA code to sort a listview column header on click. Not only default column, any column in listview can be sorted, with a click on column header.
  • Excel vba send email with attachments using Outlook App Mass Bulk email
    Bulk Excel VBA Send Email with Attachments – 2 Multiple recipients
    Get Excel vba send email with attachment code that uses Outlook app already installed. Send bulk emails to multiple recipients with different email.
  • GB Whatsapp Features Smartphone Messaging App Download page
    GB Whatsapp Features – Easy Download Steps
    Learn GB WhatsApp features compared to the original WhatsApp app. It offers enhanced security, privacy settings, customizations & more
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved