what is the method to select a single item in the list box

[#1]

Hi,

what is the method to select a single item at a time in a listbox.

Regards

Chriss

[Nicole-Smith]

Select a value in the listbox, go into Properties for the listbox, select the option "Always One Selected Value".

[jagan]

Hi,

For this you need to do the following steps

1. Select single value in listbox

2. Listbox properties -> Select "Always one selected value" option.

Hope this helps you.

Regards,

Jagan.

[MayilVahanan]

Hi

Try like this

Listbox properties -> General -> Always One Selected Value

Before that, please select a value in the filter.

Hope it helps

[#5]

Hi All,

Thanks for your reply, I would like to mange this in a script see below bold part, doc.Selected (Object doesn't support this property or method: 'doc.Selected').

How do I mange, please help...

Sub SelectCustomer

Set doc = ActiveDocument.GetSheetObject("LB01")

boxvalues = doc.GetPossibleValues

for i = lbound(boxvalues) to ubound(boxvalues)

   ' msgbox(boxvalues(i))

   doc.Selected

   call ExportToExcel

next

End Sub

[#6]

Hi,

Is anybody can help me....

Regards

Chriss