Insert Name Define

Name:= ListA

Refersto:= =Offset(Sheet1!$A$1,1,0,counta($A:$A)-1,1)

click ADD


then in the rowsource property type in

ListA

--
Regards,
Tom Ogilvy



" wrote:

Is it possible to change a listbox's rowsource property equal to a
dynamic range using a variable in design mode? If so, how does one do
so? Thanks, Abe