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

bysimon
181

Auto Generator button and Clear All


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

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

Excel VBA

23

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

I need to carry

Troubleshooting Solution

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

31

Dear experts,


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

Advice Solution

Looking for Replacement Architecture Recommendations

59

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

Article

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.
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.
Troubleshooting Solution

Preselect listbox items and map to another listbox

151
Expert,

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

VBA Code to Parse a Name into Separate Columns in Excel

94

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

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

Find the horizontal and vertical repeats for all three sections B

70

29263897a (1).xlsm


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


 as shown :

Troubleshooting Solution

Query column colors do not transfer to combo box

20

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

Troubleshooting Solution

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

88

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

Troubleshooting Solution

Query doesn't work by code.

bybfuchs
32

Hi Experts,

I am experiencing something strange.

I have a query that when I run it normally from the

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

create the top count  for 3nb

53

29264305.xlsm



In sheet 3B:


1. Create the mid-top for AM columns  AH to AN


2: Create the triple top for

Troubleshooting Solution

Access 2016 VBA Code Opening Takes A Long Time

34

Hi Experts.


For a few months now with Access 2016 when I first open a Form Event that is VBA Code it

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more