need to return "Not Found" value

[Sway1978]

Hey all - I have a functional user form in excel with dependent combox, that pulls data from a hidden worksheet. I need some ideas to alter the existing code to return "Not Found" value if no matches were found in ComboBox3

Please Login or Register  to view this content.

any assistance would be helpful.

[The_Prist]

try it:

Please Login or Register  to view this content.

[stnkynts]

It probably would have been better from the get go to use the Find method rather than a loop but keeping with you current version this should work

Please Login or Register  to view this content.

[Sway1978]

it works but the message box creates a conflict when I attempt to use my clear command - the Suptxt field will not clear the data (unless the clear command is selected twice). Is it possible to have the NOt found response appear in the Suptxt and Sitetxt fields. that would eliminate the msgbox?

[Sway1978]

never mind . I figured it out thanks for your assistance everyone.