Validation List Calling Macros

Newbie user of VB. I need some assistance on a project. I have a form that uses a validation list ( cell c5) to populate other cells (c6, c7, c8, h5) using Vlookup.

This part works fine. On the list is an "other" choice which I need to initiate a textbox macros which would accept user input and populate the same cells with the entered data once a cmd button is selected. I’ve tried redefining my variables as ranges or strings with the same inconclusive results. The code as it stands looks like this:

Private Sub Worksheet_change(ByVal Target As Range)
Dim Vname As String
If Intersect(Target, Range("c5")) Is Nothing Then
'do nothing
Vname = Target.Value
If Vname = "" Then
'do nothing
If Vname = "Other" Then Newvendin.Show
End If
End If
End Sub

Using this code doesn’t initiate the event.

Newvendin is the userform to enter new data only if “other” is selected. CmdEnter is the enter button on the userform with textboxes in it. I’m having a bit of trouble with it’s code as well.

Private Sub cmdEnter_Click()
Dim ws As Worksheet
Set ws = Worksheets("OSP Parts List")
ws.Cells("c5").Value = Me.Vname.Value
ws.Cells("c6").Value = Me.Vadd1.Value
ws.Cells("c7").Value = Me.Vadd2.Value
ws.Cells("c8").Value = Me.Vcont.Value
ws.Cells("h5").Value = Me.Vphone.Value
End Sub

The Vxxxxx are the textboxes.

I get type mismatch errors using this code.

I would like it to populate the value typed into the textboxes into the indicated cells.

Final question and it’s probably stupid. If you have more than one Private Sub Worksheet_change(ByVal Target As Range) sub on your worksheet, how do you change the wording on each so that it won’t cause an Ambiguous name detected error?