We help IT Professionals succeed at work.
Get Started

Excel VBA Multiple Word Column Headings with Data Validation

Last Modified: 2017-04-10
I've run into an issue in adapting some Excel VBA code from one template to another.  I know the reason behind the problem is because I have data validation lists with headings that include multiple words, such as "A and B," or "A B and C D," instead of a single word heading like "A" or "B."  I tried inserting a substitution line of code into the ShowAutoComplete module, but it didn't do anything.  I also tried inserting a Split code into the same module that would address the validation formula that has indirect in the code.  That I took from Contextures, but all that did was stop everything from working.

Watch Question
Keep everyone healthy; Wear a mask - Social distance - Don't touch your face - Wash your hands for 20 seconds
Most Valuable Expert 2017
Distinguished Expert 2020
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE