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

June 06, 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

June 06, 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

June 06, 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

June 06, 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

June 06, 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

June 06, 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?

June 06, 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

June 06, 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

June 06, 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

June 06, 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
  • Word Mail Merge as Mass E-mail Marketing Services
  • Find Synonym for Selected Text using MS Word VBA
  • VBA to open or save Word document Protected or Encrypted with password
  • Best Free Online PDF to Word or Excel Converter
  • Excel VBA Get Username – in 6 Easy ways – using Macro
  • Password Protect Excel 2010 & 2007
Dropdown Tricks
  • Remove Drop Down data validation list from Excel & VBA
  • How to remove Drop down list in Excel?
  • How to create Drop down data validation list in Excel?
  • [VBA] Read Values in Data Validation Drop Down List
  • Add Excel VBA Drop Down Data Validation List
Excel Tricks
  • Archive Facebook Messages – JSON to Excel
  • Excel VBA For each cell in Range – Direct method
  • Excel Vba RGB to Hex,Long – Hex to Rgb,Long – Color Code Conversions
  • How to Lock a Folder In Windows – Easy Excel VBA Code
  • Login to Facebook, Twitter, Google+ in IE from Excel
  • 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