check that user selected a value in a list box

[joncohen]

I am trying to validate if a user selected a value in a listbox. Does anyone
know how to display a message if the listbox has no selected values?

Thanks in advance.

Jonathan

 

[Helmut Weber]

Hi,

listindex returns -1
if no item is selected.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[joncohen]

Helmut,

Thank you for your reply, my issue is that the msgbox displays twice after
verifying that the listbox does not have a selected item. I must be missing
where to validate the listbox so that i can return the user back to this
listbox. Any assistance would be appreciated, thank you.

 

[Helmut Weber]

Hi Joanthan,

as Jay pointed out, make sure,
that there is always something selected.

I'd add an entry like "---" as item 0,
select always item 0 as the default item
and check afterwards,
if an item other than item 0 was selected.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"