Excel Phonebook

[sethu29]

Hi
I created one phone book in excel. But when i click search contacts, it showing
Run time error 5
Invalid procedure call or argument.

Can anyone help

[Kenneth Hobs]

Use Debug to find those problems. Since debug stops at:
UserForm1.Show True then that is a place to start. True is a value of -1. Since the parameter can only be vbModal a value of 1 or vbModeless a value of 0, you now know the problem.

[sethu29]

even though it showing "run time error 5 invald procedure call or argument"
Please help

[Kenneth Hobs]

Apparently, you did not understand my response about vbModal and vbModeless. You don't really need either though as you can set the modal state in the ShowModal property of the userform. In that property, yes, set ShowModal=True. The help for Show explains modal.

Sub Rectangle5_Click()
UserForm1.Show vbModeless
End Sub