Thanks so much, Dave! It's embarrassing that it was that simple, but when
you can't get it to work it seems so hard!

"Dave Peterson" wrote:

I could manually type in the range that I wanted:

'Data Formatting'!A1:A13

(note the single quotes and exclamation mark)

In code:

With Worksheets("Cover Info").ListBox1
.ListFillRange = Worksheets("data formatting").Range("a1:a13") _
.Address(external:=True)
End With



LostinVA wrote:

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.)

--

Dave Peterson