How to create a dialog box to input information to worksheet?

[joromajr]

I'd like to create a dialog box to input information such as "client's name",
"address"', "date of visit", etc... dialog box should also function as search
tool to locate details of client once any information of the client is
encoded in search section.

 

[john]

You can use excels built in dataform to do what you want.
Assuming your data is laid out in a database table like format with Row 1
used for Headers - place this code in standard module & run. A form should
appear where you can add, delete search etc your data.

Sub ShowForm()

With ActiveSheet

.Range("A1").Select
.ShowDataForm

End With

End Sub

Hope helpful