yes, it is on another sheet, and it does "disappear" on me. How do I get it
to pull from another sheet?

" wrote:

hi,
is the listfillrange on the same sheet as your listbox. if
it is on another sheet, it will "disapear" on you or
reference the range on the same sheet with the list box.

-----Original Message-----
I'm trying to create a listbox named ClientStatus from
Control Toolbox
toolbar on worksheet 'Cover Info'. My list data is in
column A of worksheet
'Data Formatting'. It won't let me enter anything in the
ListFillRange under
Properties, and I can not for the life of me figure out
how to use the
ListFillRange in VBA. (I'm new to all of this. Just
learning by reading
other's answers.)
.