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

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

Hi Tom--Thanks for your help, but I am still missing something. I have
programmatically defined the name in the initialize routine of the
userform and then typed the name ("list A") into the rowsource property
but nothing is happening. I have changed the name to refer to a certain
range on the active sheet, so perhaps that is the root of the trouble.
Any ideas?

Nevermind, I have solved the trouble. Rowsource takes the info in
certain rows (duh!) and I need info for certain column headings.