Anyone know a good excel user form how to

[jsox79]

Rather than have someone solve my problem id love to atleast try to figure it out on my own.

I have a working form which i found on the net, i edited it to suit my needs. it basically adds data to a table in a sheet. basically a customer db. first name, last name, address, phone, city state. id like to add a form to recall data based off of the phone number or name. this is very simple in excel using vlookup or index and match, but vba is new to me. if there is a good how to or term explanation i would be very grateful. Thanks for your time.

 

[pedro-egoli]

Google "excel function dictionary".

Download from site of your choice. Lots of functions explained

Pedro

 

[jsox79]

thanks

 

[jsox79]

Thanks, but this excel functions. I know how to use excel just fine. im looking for visual basic commands and form data structure. im pretty swift with examples i just need to know the right commands and their purpose.

like:

'check to see if txt box empty
If Trim(Me.txtphone.Value) = "" Then
Me.txtphone.SetFocus
MsgBox "Please enter a Phone Number"
Exit Sub
End If

I can look at this code and tell that it is:
checking for blank value in first line
if it is then its setting cursor to that box in second line
and msg box please enter ..... on third

generally i can look at an example and form my own code, but i dont really know how to call it back, and what commands would be used.
Any help is appreciated.