Explore VBA on Experts Exchange

Expert Solutions for Your Tech Problems

VBAVBA

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
Martin Liss
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

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

Getting your EE Ranking statistics in Excel

byQlemo
90
The code described here does no longer work. Please see replacement Article: …
Video
Using Automation to Control Outlook from Access 5m

Using Automation to Control Outlook from Access

byTechMommy
2
Get people started with the process of using Access VBA to control Outlook using automation, …
Post

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

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

Tracking timecard hours automatically in Excel against two different online Timecard formats

byphoffric
110
Ref: …
Troubleshooting Solution

data to match 3N ddu file

byADRIANA P
49
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?

bystephenlecomptejr
34
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

bybillpars
29

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

…
Article
Oh no

A Guide to Writing Understandable and Maintainable VBA Code

byMartin Liss
14
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.
Post

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

byGustav Brock
1
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?

byLenny Gray
20
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

byADRIANA P
29
 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

byMelbut
151
Expert,

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

New member today got a solution today.  After searching …

byKyle Santos
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

bymarku24
16
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

byTom Crowfoot
22
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

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

29173941.xlsm.xlsm


Troubleshooting Solution

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

bystephenlecomptejr
22
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

byJames Robinson
24
Hi,
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

byawesomejohn19
19
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

Collaborate

Monitor your Site

Explore solutions and more