How do I Modify STRING Shape Data using an Action formula (menu selection)

		Microsoft Office Forums > Microsoft Office > Visio
How do I Modify STRING Shape Data using an Action formula (menu selection)

FAQ

Thread Tools

Display Modes

04-05-2021, 08:14 PM

Guessed

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: 4,185

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

« Previous Thread | Next Thread »

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
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 01:09 AM.