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
President / Owner CARDA Consultants Inc.

Making your data sing and fixer of broken things.

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

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 realtime activity tracking

bysimon
99

I have sample table  attached for "Excel Realtime Activity Tracking"

Time Management.xlsx


Requirements

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

Copy of Record and Whatif tab to get start month of Jan 21 onwards.

bysimon
59

If a copy of Record and What if tab could be created so that the start month in the Record tab could

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

create button from  the source file 4n

79

29248734 (1).xlsm 4n 


source file :29234426 (11).xlsb


1-create  the button in 29248734 (1).xlsm 4n

Troubleshooting Solution

create the sheet pair data

70

29246420a (6).xlsm 3B


1- Create the PAIR sheet from  3B sheet


2-Broke 3n (column K)  in 3 pairs (

Troubleshooting Solution

Userform in Switched on mode after  Clicking Calculate Win button and automating monthly totals

bysimon
47

1) Requesting  to make the userform stay switched ON  after  clicking the Calculate Win button , so

Troubleshooting Solution

Ranking by Groups in 1to 80 tab

bysimon
111

Ranking system similar to  lotto table ranking that would work for 2,3,4,5,6 and 7 numbers.
 

A hot

Troubleshooting Solution

Items Locator Excel Workbook

bysimon
75

What I was looking for here was  assigning items(things) to headings and then add photos for every

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 a list of selected emails

bybfuchs
28

Hi Experts,

I am getting lot of emails from one vendor and would like to concatenate them all into

Advice Solution

Adding Record and Expenses tab for Keno Workbook

bysimon
97

Requirements :  File attached  RecordNExp tabs Keno.xlsx

In Record tab, I will be inputting data

Troubleshooting Solution

Number Generator for Wins Calculator tab

bysimon
27

Request for a Number Generator that can be integrated into the exisitng userform palette below of

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

How to filter in MS Access for date/time values in a query?

19

How does one filter in a Microsoft Access query both date/time together on a field?

Please note

Troubleshooting Solution

What if Scenario User from

bysimon
36

"What If" userform that would allow me to select a played draw/ unplayed draw and then allow  to

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more