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

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

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

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

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

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

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?

126
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

70

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

88

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

116
Expert,

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.

bysimon
117

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


Requirement.

Delinking MG Tab

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more