Alphaboss7
New Member
- Joined
- Jul 31, 2017
- Messages
- 28
Range("A" & .ListIndex).Value
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
What does this VBA code do?
- Thread starter Alphaboss7
- Start date
-
- Tags
- .listindex.value code rangea vba
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 13,335
Welcome to the forum.
As is, that doesn't do anything. However, ListIndex is a property of a listbox, which you might find on a userform. So if the listbox is populated with items stored in column A, .ListIndex would return the offset of the selected item, and the Range would return the actual item (but it would be off by 1).
As is, that doesn't do anything. However, ListIndex is a property of a listbox, which you might find on a userform. So if the listbox is populated with items stored in column A, .ListIndex would return the offset of the selected item, and the Range would return the actual item (but it would be off by 1).
Upvote
0
Similar threads
- Question
- Question
