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
  • 15K Content
  • 1.2K Contributors

Expert Spotlight
Keep everyone healthy; Get Vaccinated

Almost 50 years of programming experience. Click '+ More' in my "Full Biography" to see links to some articles I've written.

Troubleshooting Solution

color by column

80

=29231070b.xlsb  4N 


1-Adjust  button TRIG in BS1 to show the TRIG-F as the priority  when look up in

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

4n to be  Modify   to work with  3n DATA -- week num

96

4n to be  Modify   to work with  3n DATA--buttons in sheet byplay

29228882.xlsb


1- Modify   to work

Troubleshooting Solution

Script to update Lookup list worksheet

byMelbut
121
Experts,

I need help with a script that updates the Lookup list worksheet columns A-B and  E- H with …
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

add userform  to columns

47

29230779 (1).xlsb


1- create userform  for each column  from AL to AZ 


in CONSE sheet 


2- each column is

Troubleshooting Solution

Excel VB Macro help

36

Need a VB Excel Macro that will calculate an AssigneeList for a given asset using the data format

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

add data with button  for 4n

70

4n to add button in DDX sheet and  TRIG sheet

29226355a (1).xlsb


1- in BYPLAY sheet  A1 is PLAYS

Troubleshooting Solution

identify  tri in 2 weeks

56

4n to mark the shown tri in DD-X fro 1 and 2 weeks

29227555 (1).xlsb


1- with  one week green 

2- with

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 sheet

36

29230206a.xlsb


1- create sheet CONSE create button to GET DATA from sheet1 BF 


2-from column R to

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

match with table data 2N

19

29231616a (3).xlsm 2N


1- In DTO columns AJ  to AX is table  2DR


2- match column  BF sheet1 with

Troubleshooting Solution

Create key and  create button

23

29231180.xlsb file 3n


in sheet1  

1-create the key for DD from column AT  in the column AK as shown 




Troubleshooting Solution

Has VBA been fixed so that Control Break always works?

19

Has anybody else noticed that Microsoft has finally fixed VBA so that control break always works?
And

Troubleshooting Solution

userform for column bx 4npairs

64

4N fille to add BX from 

29223939.xlsb

When I click the Select TK Vertically button the userform in

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more