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

Excel VBA change selection in Dropdown

May 09, 2025
Kumarapush

[VBA] Change Selection – Update Drop Down List in Excel This does not require any special code. It can be done just by changing the value in the particular cell that has a validation list. Here is an example VBA code that changes the selection in a drop down validation […]

Excel Charts Color Excel VBA Macro PDF

Convert Excel to Jpg Image – VBA Code

May 09, 2025
Kumarapush

Export Excel Range to Image (jpg/png/gif) using Vba? This code ill convert the data in Excel workbook into a jpg image file as how it is displayed on screen. The image format can be jpg, png or gif. We have not tested if this supports other image formats as well, […]

Sort Collection Data Type VBA Array

Excel Vba Sort Array – Quick Trick using built in function

May 09, 2025
Kumarapush

VBA Array Sort – Using Excel Sort In this page, we have given a Excel vba code snippet that works well for sorting array of 1 dimension. You can also customize & extend this code to work for 2 dimension array as well. We will publish the code for 2D […]

VBA Array Collection Data Type Dictionary

VBA – Create Array from Excel Range – 1 Dimension

May 09, 2025
Kumarapush

Excel Macro – Create 1D Array from Vba Array This is one of the easy methods to initialize an array. If you convert data in worksheet directly to vba array, then it will create a 2d array by default. If you would like to convert Excel range to Array of […]

VBA Array Data Type

VBA Array Initialize Values – Split string to array

May 09, 2025
Kumarapush

How to Initialize an Array in Vba? Different methods to assign values to array are explained here. Starting from basic to few easy methods to initialize array with multiple values are discussed in here. Here are the list of available methods. Direct or a loop method. Using VBA function Array. […]

VBA Array Collection Data Type Dictionary VBA Beginners

VBA – Add Items to Array – Dynamic Resize without erasing data

May 09, 2025
Kumarapush

How to add new item to existing array? In VBA, an array is always an fixed size of data values. If you have to add new item, then size of the field also has to be changed. Lets see an example: Consider you have an array like the below one: […]

Excel VBA Macro System Control Windows

How to find your VBA Version – V6 or V7?

May 09, 2025
Kumarapush

How to find Your VBA Version? The below code will get the VBA version detail using pre-compiler directives. We cannot display the value in thee variables. But it can be used inside the #IF. Then we can print the required values. Here is the code that can fetch VBA version […]

Email Excel VBA Macro Gmail String Operation

Validate Email Address – VBA Code – Excel

May 09, 2025
Kumarapush

Verify Email Address Format in VBA Code in this page will verify if a email id is in proper format. This code uses regex pattern matching. To do this, first You need to define a regular expression pattern that will match a valid email id. A email id has a […]

Folder Operations Excel Excel VBA Macro Security

VBA get Path to Default Temporary folder

May 09, 2025
Kumarapush

VBA – Find Temporary Folder Path To save any intermediate data files, instead of creating a folder, You can use system default temporary folders. This way, there is less coding effort required to manage the new folders. But, to do that, You need to first find the folder path. There may […]

MS Word File Operations PDF

How to Convert Docx to PDF – VBA Save Word as PDF

May 09, 2025
Kumarapush
0

Learn how to convert a docx to PDF file using different methods. Also using the VBA code save word as PDF or using the menu option of your choice.

Posts pagination

Previous 1 2 3 4 … 17 Next
MS Word Tricks
  • VBA to open or save Word document Protected or Encrypted with password
  • Excel VBA Get Username – in 6 Easy ways – using Macro
  • Word Mail Merge as Mass E-mail Marketing Services
  • Password Protect Excel 2010 & 2007
  • Find Synonym for Selected Text using MS Word VBA
  • Best Free Online PDF to Word or Excel Converter
Dropdown Tricks
  • How to create Drop down data validation list in Excel?
  • Add Excel VBA Drop Down Data Validation List
  • How to remove Drop down list in Excel?
  • Remove Drop Down data validation list from Excel & VBA
  • [VBA] Read Values in Data Validation Drop Down List
Excel Tricks
  • Excel Vba Save a Copy of Workbook with TimeStamp
  • Excel VBA – Convert Column Number to English Alphabet Letter
  • Convert VBA Declare Compatible with 64 Bit Office
  • Compare Two Excel Sheets – Highlight Differences – Macro VBA Code
  • VBA Convert Excel range to JPG Image
  • Creating Folders Using Python: A Simple Guide
  • A Simple Guide to Copying Excel Sheets
  • Retrieve All Files in a Directory using Python
  • Creating Folders in Outlook: A Guide
  • Chandrayaan 3 Live Stream Today – Vikram Lander
  • Creating Folders Using Python: A Simple Guide
    As the world of technology continues to advance, it becomes evident that the ability to manipulate, create, and manage digital spaces is of utmost importance. Python programming language is among the most powerful tools capable of such feats. This exciting exploration commences with an introduction to Python, providing essential knowledge […]
  • A Simple Guide to Copying Excel Sheets
    Navigating the intricate landscape of Microsoft Excel can often seem like a daunting task. This software, with its abundance of features, functions, and commands, requires a keen understanding to fully utilize its potential. Whether you’re an industry expert or a novice user, mastering the art of manipulating Excel sheets is […]
  • Retrieve All Files in a Directory using Python
    In our digitally driven world, where data processing and management are integral to many industries, the ability to work with Python has become an invaluable skill. This language, particularly in relation to file and directory manipulation, grapples with the rapid growth of data and its intricate handling. With its intuitive […]
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved