VB Script to Change Yes/No value to True/False

I have some worksheet data that is imported from a work application, and some values show up and Yes/No but my boss, for whatever reason known only to him, wants these values changed to True/False. Currently this data resides in column D:D. I am struggling to figure out how to do this via vb code. Any suggestions?

VB ScriptVBA

Last Comment

scsyme

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Rgonzo1971

3/23/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

scsyme

3/23/2015

How is the data imported? What is the driver to use VBA rather than just find/replace? Are the values in D:D only ever Yes or No? Is there scope for inserting column E and using a formula driven by the values in D rather than resorting to VBA? How often will this import / transformation process need to take place?
Any other info to help us more fully understand the requirement?

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

Certified Expert Program

Credly Partnership

Udemy Partnership