troubleshooting Question

Excel VBA and Textbox value

Avatar of sandramac
sandramac asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
2 Comments1 Solution1926 ViewsLast Modified:
Hello

Trying to get a vba code to get value of textbox 2 located on sheet 29 to display the value of sheet 20 I68 and I69 in percent format.  An example would be if I68 was .22 and I69 was .30 then Textbox 2 would display  22%/30% in black font.   In addition if either value is greater than .90, then color fill textbox purple, if 80 to 90, then red fill, 60 to 80 orange fill, 40 to 60 yellow fill, else green fill.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
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 2 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