We help IT Professionals succeed at work.

Troubleshooting a Macro for Doubleclick a Character in a Range Cell

157 Views
Last Modified: 2017-04-20
Martin Liss helped me with a Macro to create certain characters in a Range name group when you double clicked.  I've made the changes but cannot get it to work correctly.

Please take a look and see if there is an easy fix.

B.
Check-Boxv2.xlsm
Comment
Watch Question

Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
What part isn't working and what do you want it to do?
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
In the Toggle sub change

Case CHECKMARK ' It's a checkmark so change to ?

to

Case "P" ' It's a checkmark so change to ?
Social distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Martin,

Thanks!  Seems to work well.  I'll test it further but really appreciate the quick and responsive assistance.

B.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.