Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Visio

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-22-2019, 12:16 PM
natelfo natelfo is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2017
Posts: 6
natelfo is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-22-2019, 01:20 PM
natelfo natelfo is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2017
Posts: 6
natelfo is on a distinguished road
Default

***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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto populate form (data from excel) in Word based on drop down list selection (data from excel) wvlls Word VBA 1 03-22-2019 02:29 PM
How do I add selection of multi line content control list to specific table cell Dudlee Word VBA 1 09-20-2016 04:58 PM
Selection from cell with list contents autopopulates contents of another cell markharper80 Excel 3 02-16-2015 04:18 PM
Draw a selection box over a shape omberlo PowerPoint 1 11-25-2012 06:44 AM
Change cell color when selection is made from a drop down list fedcco Excel 12 08-28-2012 10:43 PM


All times are GMT -7. The time now is 09:54 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft