Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2021, 08:16 AM
TJF0700 TJF0700 is offline How do I Modify STRING Shape Data using an Action formula (menu selection) Windows 10 How do I Modify STRING Shape Data using an Action formula (menu selection) Office 2019
Novice
How do I Modify STRING Shape Data using an Action formula (menu selection)
 
Join Date: Apr 2021
Posts: 1
TJF0700 is on a distinguished road
Question How do I Modify STRING Shape Data using an Action formula (menu selection)

So - I've been pulling my hair out for 2 days trying to figure out what seems like it should be simple. I have a shape with Shape Data defined. Hosted_Type is the field and it is set to String.



In my Action I have:
=SETF(Prop.Hosted_Type,"Trading Partner")

I've also tried (among 10 other things):
=SETF(GetRef(Prop.Hosted_Type),"Trading Partner")

And just setting it as so:
=Prop.Hosted_Type="TestData"

Nothing works to date. Exception:
=SETF(GetRef(Prop.Hosted_Type),1)

If I use a number instead of text, the Property in the Shape Data gets updated.

Am I missing something? This seems so basic, yet I cannot find a single piece of documentation on how to set a Shape Data field to TEXT based on a menu choice. Nor do I find any documentation that states this cannot be done.

Thank you for any help!
Reply With Quote
  #2  
Old 04-05-2021, 08:14 PM
Guessed's Avatar
Guessed Guessed is offline How do I Modify STRING Shape Data using an Action formula (menu selection) Windows 10 How do I Modify STRING Shape Data using an Action formula (menu selection) Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You need to use triple double quotes - The outer set encloses a string, the next quote serves as an escape character and the third one is included in the value entered in the cell.

=SETF(GetRef(Prop.Hosted_Type),"""Trading Partner""")
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changes to Home Slide after random selection of an action MParson8297 PowerPoint 1 07-25-2019 12:36 PM
Shape Data - Using Fixed List selection in another cell's formula natelfo Visio 1 04-22-2019 01:20 PM
Modify right-click context menu to only allow pasting text derajlance Word VBA 0 05-24-2016 02:25 PM
How do I Modify STRING Shape Data using an Action formula (menu selection) Selection doesn't contain the action Ulodesk Word VBA 2 10-21-2011 05:59 AM
Highlighted Selection on Action Settings mos7sad PowerPoint 0 10-12-2009 07:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:52 AM.


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