asked on VBA ListBox - get the value of the selected item and dislay it in a message box
I am displaying a few strings items on ListBox on a Form. I would like to display the value of the item (which is a string) displayed in a message box when I click on it. I would appreciate your help.
Microsoft OfficeVBAMicrosoft Word
Last Comment
FaheemAhmadGul
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you for your comment. This does not work, however. We need the value of the selected item and not of the ListBox - that is we want to display the value of the item on which the user clicks. This will involve finding out which item the user clicked on and then fidning its value.
That code should show you the item that's been clicked in the listbox because Value returns the value of the selected item in the listbox.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Many thanks. Actually both the solutions work. I have split the points - more points to Norie because that solution was post first. Hope this OK.