troubleshooting Question

Changing a % to $ and $ to %

Avatar of Bright01
Bright01Flag for United States of America asked on
Microsoft Excel
10 Comments1 Solution338 ViewsLast Modified:
EE Professionals,

I'm looking for a simple macro that is driven by a change to a cell (see Sample; Cell E5).  If the Condition is set to % then the input cell is represented as a % and the calculation is made as D5 * E5% and placed in F5.  If the button is pressed and changed to $, then the value in cell E5 is changed to a $ value and F5 is recalculated as D5-E5$ and placed in F5.

It needs to be separated into 2 subroutines; one for % and one for $ change so they can actually be called from other macros to impact the same cells.  Big cudos for actually making the button change from $ to % when clicked and selecting the right macro.

Make sense?

B.
Example-of-Macro-for-changing---.xlsm
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros