Microsoft Office Forums Shape Data - Using Fixed List selection in another cell's formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2019, 12:16 PM
natelfo natelfo is offline Shape Data - Using Fixed List selection in another cell's formula Windows 7 64bit Shape Data - Using Fixed List selection in another cell's formula Office 2010 64bit
Novice
Shape Data - Using Fixed List selection in another cell's formula
 
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 Shape Data - Using Fixed List selection in another cell's formula Windows 7 64bit Shape Data - Using Fixed List selection in another cell's formula Office 2010 64bit
Novice
Shape Data - Using Fixed List selection in another cell's formula
 
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
Shape Data - Using Fixed List selection in another cell's formula 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
Shape Data - Using Fixed List selection in another cell's formula Selection from cell with list contents autopopulates contents of another cell markharper80 Excel 3 02-16-2015 04:18 PM
Shape Data - Using Fixed List selection in another cell's formula Draw a selection box over a shape omberlo PowerPoint 1 11-25-2012 06:44 AM
Shape Data - Using Fixed List selection in another cell's formula 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 07:36 PM.


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