Link to home
Start Free TrialLog in
Avatar of Rrave26

asked on

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?
Avatar of Rgonzo1971

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?