Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 07:16 PM.


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