Numbers Directory

[aziztt]

After looking at various websites for help, ive managed to create a usable Numbers directory, the main souce of help was from ozgrid vba site

Im happy that it list which department the user choose but i want to provide a search system where it searches for any strings of the Name of the numbers

Have a look at the attachment, and help would be great

If anyone has other easier solutions, even better

[jayzeus]

I think this would be easier (and quicker) to simply import that into an access database, and simply run a search query....?

[aziztt]

Ive built everything in excel and want an easy userform to display the required number

as u can see its a simple userform to display the correct numbers, i just want a search system built into it