okay I will break this down for ya.

I have a bunch of 6x6 squares. Each one of those has a named range.

Basically I'm making a township/range map of the metro area in my state.

I don't know if your familiar with township/ranges but each township/range has 36 sections, thus my multiple 6x6 squares which are broken down into named ranges

named range = township/range

I locate underground facilities and I am part of a district that has 9 supervisor groups. I am attempting to make a sheet that dispatch can use. They will take the township range from the One Call Dig center ticket, input it in text box and then it will highlight that township/range.

each superisor group will be color coded and have certain township/ranges assigned to them, thus when it finds the named range they will know what supervisor to dispatch the ticket to.

Right now I am able to do this, but through the use of a combo box. I was trying to eliminate them having to choose the correct township/range from a long list.

Does that make sense or just make things worse....ha ha