Hi Guys,
I'm new to this forum. Also a newbie in Excel/VBA.
I'm trying to create a "search-engine like" on Excel with compiled process updates of our work.
I used, auto suggest search engine and userform to view the image. It's quite difficult and needs a lot of work since I have to put Userform every updates we get.
Whenever the mouse is dragged to 2 or more cells I alwasys get this error Type Mismatch Run time error 13. Please help me with this one. I'll appreciate it. Thank you.


VBA:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Selection.Value = "Matching new professions" Then
frmMNP.Show
ElseIf Selection.Value = "New Dentists specialty" Then
frmNDS.Show
ElseIf Selection.Value = "OH Nurse SLN" Then
frmONS.Show
ElseIf Selection.Value = "Disabled Dentists SLN" Then
frmDDS.Show
ElseIf Selection.Value = "CSP Instructions" Then
frmCSPI.Show
ElseIf Selection.Value = "Nevada Nurses" Then
frmNN.Show
ElseIf Selection.Value = "Florida Pharmacists Interns" Then
frmFPI.Show
ElseIf Selection.Value = "Nevada Nurses and expired SLN" Then
frmNNES.Show
ElseIf Selection.Value = "South Carolina Optometrists SLN" Then
frmSCOS.Show
ElseIf Selection.Value = "California SLN" Then
frmCS.Show