I'm curious how you 'created a dialog box'. Do you mean UserForm?
cfree36, I'm not saying that using a sheets code name is a bad thing, it's just not my personal preference. It can be difficult at times when dealing with code names from other workbooks and I find it to be more cumbersome. There really isn't anything wrong
with what you posted, just not the way I do things.
There are many ways to skin a cat.