Posted to microsoft.public.excel.programming

Otto Moehrbach Otto Moehrbach is offline

external usenet poster

Posts: 1,090

Trapping NO selections

Excel 2002, WinXP
I have a UF with a multi-selection ListBox, lbNMFee.
I want to act on the instance wherein the user makes no selections in the
ListBox. I have the following argument that is True if no selections are
made. This code is in the beginning of the macro that is called by the OK
button click.
Is this correct? Thanks for your help. Otto

If UFMgtFee.lbNMFee.ListIndex = -1 Then

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
error trapping	[email protected]	Excel Programming	2	January 20th 05 10:07 PM
Trapping #NAME? question	Stuart[_5_]	Excel Programming	7	February 29th 04 02:52 PM
trapping error	RobcPettit	Excel Programming	2	January 30th 04 03:37 AM
Error Trapping	Neil	Excel Programming	1	January 5th 04 04:38 PM
Trapping the mouse	Sam K	Excel Programming	1	July 27th 03 02:55 PM

All times are GMT +1. The time now is 12:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us