Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please let me know if there is a way to set the row height of an expression with a variable.
Kindest Regards
Werner
Werner,
example is attached. Please note that you can't change line height for specific expression only -- it can be changed for all table only.
VB macro is as follows:
sub SetExpressionRowHeight
set chart = ActiveDocument.GetSheetObject("CH01")
set cp = chart.GetProperties
set var = ActiveDocument.GetVariable("vHeight")
cp.TableProperties.Multiline = var.GetContent.String
chart.SetProperties cp
end sub
Macro is called when variable vHeight changes. This is defined in Document Properties -> Triggers
I would try doing following:
1. Write a VB macro that changes the wrap cell property of target object (straight table) depending on value of the variable
2. Go to Document Properties -> Triggers and set action OnChange for the variable to run that VB macro
Can you please assist me with an example that will do just that?
Kindest Regards
Werner
Werner,
example is attached. Please note that you can't change line height for specific expression only -- it can be changed for all table only.
VB macro is as follows:
sub SetExpressionRowHeight
set chart = ActiveDocument.GetSheetObject("CH01")
set cp = chart.GetProperties
set var = ActiveDocument.GetVariable("vHeight")
cp.TableProperties.Multiline = var.GetContent.String
chart.SetProperties cp
end sub
Macro is called when variable vHeight changes. This is defined in Document Properties -> Triggers
Werner, does this solution work for you? If yes, please mark it as answered question. Thx.