Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have to show and hide expression in a straight table,based on the user selection from a list box. In Qv11 we have option for that. Bt is there in any possible to achieve the samein Qv10?
Thanks in Advance..
Hi,
I found the solution..since it is a straight table.it has conditional option available in Presentation Tab.
Thanks
Unfortunately Not. However, alternate solution could be using multiple similar charts with conditional appearance.
Hi Reena,
You can try using Macro
Sub ShowHideExpression()
set chartObj = ActiveDocument.GetSheetObject("CH01")
set chartProp= chartObj.GetProperties
set expr = chartProp.Expressions.Item(1).Item(0).Data.ExpressionData
expr.Enable = False // Hides First expression
set expr = chartProp.Expressions.Item(2).Item(0).Data.ExpressionData
expr.Enable = True // Displays Second expression
End Sub
Regards,
Jagan.
Hi,
I found the solution..since it is a straight table.it has conditional option available in Presentation Tab.
Thanks