Thread: Starting Easy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
nath nath is offline
external usenet poster
 
Posts: 57
Default Starting Easy


-----Original Message-----
Hello,

can anyone please help?

i wish to click a value in a listbox, how would i get a
msgbox say "you have selected: " & whatever the value is??

Thank you,

Robert Couchman
.
In the after change event, use


lst_val = listbox1.value
msgbox("You have selected : " & lst_val)