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
  • 14K Content
  • 1.2K Contributors

Expert Spotlight
Social distance - Wear a mask - Don't touch your face - Wash your hands for 20 seconds

Almost 50 years of programming experience. Click '+ More' in my "Full Biography" to see links to some articles I've written.

Troubleshooting Solution

Revising a Regex Function: MS Access

Hello Experts,
I need help revising a regex function that was created for me earlier this year by …

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

data to match 3N ddu file

match data in this file

29204352b (1)_match_3NDD.xlsm

1-I wish we focus on week 32w2020 as a basic
Troubleshooting Solution

Want to determine the most accurate and fastest VBA coding to determine if a table exists?

I have the following two TableExists functions.  Which one you would use as to the best?  Which one …
Troubleshooting Solution

Need Resources for Migrating Access to SQL Server


I am forced to begin a crash course in migrating a dozen (or so) Access 2016 MDB backends to SQL

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.

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

How do I stop the current form from executing steps past the VBA code that calls another form until the called form is closed?

On the calling form (frmMF_Project), there is a button to fire-up another form (frmCF_ITN_Downloads) …
Troubleshooting Solution

Create an Form to enter Data 3N

 will need create an form to enter data as shows  here

File here : 202111.xlsx
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  …

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

Create Excel workbook and worksheets from list using VBA

I have a sheet in my workbook (called "grading")  that i would like to replicate based on a list …
Troubleshooting Solution

Excel Macro Copy & Paste keep hyperlinks

Dear Experts

I have a macro in excel that copies a row from one tab ("Bio + Ed + Lang") and appends …
Troubleshooting Solution

Relative and Relative count button  don't work in 3N

in this 3n File the Relative dont show up all the DATA  either the relative count


Troubleshooting Solution

Is it possible to have a unique numeric identifier with leading zeroes in Microsoft Access?

With the following coding I keep getting an overflow error at line:
lNewValue = CDbl(sNewValue) 

Troubleshooting Solution

Report is printing 2 pages and I only want it to print the first page

I am attaching a stripped down version of my DB.  It only contains the area where I am having an …
Troubleshooting Solution

Changing a Select  - Case loop to be Dynamic

Hi, I have the following code with 5 Cases.  I need it to dynamic as I have more data. So, instead …

Do more with Experts Exchange.

Get Answers

Take a Class


Monitor your Site

Explore solutions and more