Returning a Value from a List Box in Visual Basic (124214)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
This article was previously published under Q124214 SUMMARY
In Microsoft Excel, there is no direct property to return the value
selected in a list box using Visual Basic, Applications Edition macro code.
To do this, use the index number of the list based on the selection,
and use a combination of the List property and the ListIndex property.
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | kbcode kbhowto kbProgramming KB124214 |
---|
|