Text only | Text with Images

Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: novski on January 04, 2016, 10:49:15 AM

Title: recognize text to intentionaly add a separator
Post by: novski on January 04, 2016, 10:49:15 AM
Hi
I wold like to add the text of a prop.value cell to another text cell.
But also add a separator like that "/" between the two combined texts if the prop.value cell is not empty.
So my question is, if it is possible to recognize if any character is typed to the prop.value cell.
Regards, Novski
Title: Re: recognize text to intentionaly add a separator
Post by: aledlund on January 04, 2016, 02:28:12 PM
Novski,
are you trying to do this with VBA or in the shapesheet?
Al Edlund
Title: Re: recognize text to intentionaly add a separator
Post by: novski on January 04, 2016, 02:58:32 PM
Thanks for that question. I do not use VBA related upon a company restriction in use of  Macro's in Office Products.
So only solution for me is Shapesheet.
Regards, Novski
Title: Re: recognize text to intentionaly add a separator
Post by: novski on May 12, 2016, 08:27:25 AM
I found a way to recognize text.

Try LEN() function.

Like: IF(LEN(TEXTCELL)<1,Do if Cell is empty,Do if Cell is not Empty)

Regards, Novski
Text only | Text with Images
Browser ID: smf (is_webkit)
Templates: 1: Printpage (default).
Sub templates: 4: init, print_above, main, print_below.
Language files: 1: index+Modifications.english (default).
Style sheets: 0: .
Hooks called: 53 (show)
Files included: 25 - 925KB. (show)
Memory used: 747KB.
Tokens: post-login.
Cache hits: 8: 0.00096s for 22,292 bytes (show)
Cache misses: 3: (show)
Queries used: 12.

[Show Queries]