Pre-select one value in text box

[#1]

Hi All,

I have a list box with multiple values and a text box on top of it to give a dropdown effect. When i land into the page I want on value pre populated in text box and selected. Pre-populated is fine , I could do that but the getselectedcount is 0. The value is not being selected and hence the chart does not consider that.

I really want this urgently.

Please help!

Thanks

DV

[roger_stone]

Not sure that I'm understanding you correctly, but it sounds like you need to set a Trigger on the Sheet Properties, to select a value in the list box against OnActivateSheet.

[Anonymous]

how did you preselect the value

if you use a sheet Trigger and define the Action Select in field

and define the value with ='your wantedvalue'

the field will be selected when you enter the page and getselectedcount will return a value