View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rivers rivers is offline
external usenet poster
 
Posts: 48
Default resetting a listbox after a macro

hi all

is it possible to refresh a listbox in a form after a macro has run?

the list box is poplated by options on a worksheets the user selects an
option then the listboxes options change. what i require is the selected line
to disappear again to allow the user to select a new optioin at the moment
the line selected stays blue after the macro has updated its values

thanks
rivers