Listbox selected

[fi.or.jp.de]

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.

 

[Patrick Molloy]

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.