I try not to, but don't always succeed :)

Thanks, Darren
"Tom Ogilvy" wrote in message
...
The nice thing about the Forms controls, if you turn on the macro recorder
and make a change manually, it is recorded (at least for most things). I
always find it useful. (certainly isn't the complete solution, but it
helps). So don't forget the macro recorder. <g

--
Regards,
Tom Ogilvy




Darren Hill wrote in message
...
Doh! I figured it out:

I asked:
How would I replace the line

.ListFillRange = Worksheets("GarmentTypes"). _
Range("List_GarmentTypes").Address(external:=True)

and the answer was, of course

.ListFillRange = "List_GarmentTypes"

Thanks.

Darren