View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default Listbox selected

you can iterate through for selected items

with listbox1
for i = 0 to .listcount-1
if .selected(i) then
'' do something
end if
next
end with

it really depends on how you want the data changed.

wrote in message
...
Hi All,

I have created a listbox in userform.
Listbox display details of Activeworksheet.

If two or three items in a listbox are selected.
In a single short can I update new value for those
which I have selected ? the result will be
updated in activeworksheet.

Please help me

Thanks in advance.