Microsoft Office Forums

Microsoft Office Forums (https://www.msofficeforums.com/)
-   Visio (https://www.msofficeforums.com/visio/)
-   -   Shape Data - Using Fixed List selection in another cell's formula (https://www.msofficeforums.com/visio/42323-shape-data-using-fixed-list-selection-another.html)

natelfo 04-22-2019 12:16 PM

Shape Data - Using Fixed List selection in another cell's formula
 
I have some Shape Data rows setup on shape 1. One of those rows is Prop.Letter and it contains a fixed list of A;B;C;D. If I set Scratch.A1 to be =Prop.Letter, then Scratch.A1 shows the selected value (A, B, C, or D) as it should. If I put a formula in Scratch.B1 =IF(Scratch.A1="A",1,0), or =IF(Prop.Letter="A",1,0), Scratch.B1 always shows 1, even though the value of A1 is changing to either be A or something else. How can I correctly use the result of the Prop.Letter selection as a valid value in another cell's formula? I like playing with VBA, but I would prefer that this be a shapesheet formula as it will be a master which will be used in numerous projects.

natelfo 04-22-2019 01:20 PM

***Update: I just discovered the STRSAME() function and now it works the way I need it to. I don't really understand though why "A" on one cell does not equal "A" in another cell.


All times are GMT -7. The time now is 06:56 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft