Explore VBA on Experts Exchange

Expert Solutions for Your Tech Problems


Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-le...

Read more
  • 16K Content
  • 1.3K Contributors

Expert Spotlight
Senior Data Analyst

Veteran in computer systems, malware removal and ransomware topics.  I have been working in the field since 1985.

Troubleshooting Solution

Auto Generate Button to generate number combination from a given line.


Auto Generator button and Clear All

Creation  of MG Sets two tab to inputting manually   4 to  10


Getting your EE Ranking statistics in Excel

The code described here does no longer work. Please see replacement Article:

Watch out! New PowerShell trojan discovered. Delivered by a …

Watch out! New PowerShell trojan discovered. Delivered by a Word doc that falsely claims to …
Troubleshooting Solution

Excel VBA


I have a spreadsheet with a number of columns and rows as an exported set of values

I need to carry

Troubleshooting Solution

Preselect listbox items and map to another listbox


I need  a script to add to a user form that maps list of items when one of the items  …
Troubleshooting Solution

Amendment of MAcro to include the filename from where the records has been copied and pasted


Dear experts,

Below is a macro which was put together to perform the operation of putting all files

Oh no

A Guide to Writing Understandable and Maintainable VBA Code

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Advice Solution

Looking for Replacement Architecture Recommendations


Extensive Access application currently meets client needs, and has for many years: MDB/ACCDB


Creating a custom Welcome form in Excel

Not too long ago I wrote this article on doing the same thing in MS Access (https://www.experts-exchange.com/articles/38421/Making-your-Database-More-User-Friendly.html). I found that a similar "Welcome" screen makes Excel worksheets "friendlier" as well.
Troubleshooting Solution

VBA Code to Parse a Name into Separate Columns in Excel


I need VBA code to parse a name into separate columns in an excel spreadsheet.  I did this once


I had a need for a “colour picker” for the nice original …

I had a need for a “colour picker” for the nice original Windows Phone colour palette. The codes are…
Troubleshooting Solution

Query column colors do not transfer to combo box


I have a combo box based on a query named “PriceListQuery” , I made some of the columns in this


New member today got a solution today.  After searching …

New member today got a solution today.

After searching the net for help it became apparent
Troubleshooting Solution

How to create a vba code to extract a string of data from the “View Source” code from an active IE window into a cell in excel?

I need to create a vba code that will complete the following tasks:
1.      Simulate right clicking …
Troubleshooting Solution

Find the horizontal and vertical repeats for all three sections B


29263897a (1).xlsm

1- Create the repeats by using the 2 rows with the same location number

 as shown :

Troubleshooting Solution

Trouble achieving the desired results using vba code. Need help trouble shooting or debugging the code


I am working on a dashboard and due to the formulas, vba code and other supportive information, I am

Troubleshooting Solution

Adding unlock feature to user-form for specific fields


I would like to add an unlock Service Item(SI)  feature to my user-form giving me the …
Troubleshooting Solution

Delinking MG Tab time filter and Separte time filter for MG tab.


At the moment the MG Tab is linked to the time filter of the Main tab.


Delinking MG Tab

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more