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

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
Post

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

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

data to match 3N ddu file

49
match data in this file

29204352b (1)_match_3NDD.xlsm


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

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

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

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

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 …

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?

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

29
 will need create an form to enter data as shows  here


File here : 202111.xlsx
Troubleshooting Solution

VBS script from text file

byEuro5
21
I used to use a .vbs text file to schedule an daily activity (run a macro)
It isn't working now. No …
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 …

New member today got a solution today.

After searching the net for help it became apparent
Troubleshooting Solution

Excel Macro Copy & Paste keep hyperlinks

22
Dear Experts

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

Create Excel workbook and worksheets from list using VBA

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

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

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?

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

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more