changing value of a list box
 

hi i have a userform wih a listbox withing it, i can display the
required dat with the list form, by canging the properties but cn i get
the list bx to display different info when its loaded this different
info will depend on who is using it

regards

john

changing value of a list box
 

Sure, in the initialize event, change the rowsource of the listbox to the
appropriate range based on the person.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
hi i have a userform wih a listbox withing it, i can display the
required dat with the list form, by canging the properties but cn i get
the list bx to display different info when its loaded this different
info will depend on who is using it

regards

john