ActiveX Text boxes to autofill "N/A" based on value selected on a ComboBox

[quanweitkd]

I created a form using activeX tools. I want it in a way that when the form user selects "1" for question 4 (ComboBox), then on question 5, besides the first textbox is kept blank, the other 9 textboxes will autofill with "N/A".
Then if user selects "2" for question 4, then on question 5, besides the first and second textboxes are kept blank, the other 8 textboxes will autofill with "N/A", and so on.
I am new to VBA, please advise how can I achieve this? Thanks a million!

I

 

[quanweitkd]

I attached a mockup copy of this file. you see if you test.

 

[quanweitkd]

I realised this forum doesn't allow me to attach any excel files.

 

[diddi]

dropbox works

 

[quanweitkd]

dropbox works

I am sharing the file via this google drive link:

form.xlsm

 

[diddi]

Sub SLAnum_change()
    If SLAnum.Value <> 0 Then
        For Row = 1 To SLAnum.Value
            Sheets("Form").OLEObjects("P" & Row & "TextBox").Object.Text = ""
        Next Row
        For Row = SLAnum.Value + 1 To 10
            Sheets("Form").OLEObjects("P" & Row & "TextBox").Object.Text = "N/A"
        Next Row
    End If
End Sub

 

[quanweitkd]

Sub SLAnum_change()
    If SLAnum.Value <> 0 Then
        For Row = 1 To SLAnum.Value
            Sheets("Form").OLEObjects("P" & Row & "TextBox").Object.Text = ""
        Next Row
        For Row = SLAnum.Value + 1 To 10
            Sheets("Form").OLEObjects("P" & Row & "TextBox").Object.Text = "N/A"
        Next Row
    End If
End Sub

It works! Thank you Sir!

 

[diddi]

easier with sheet to actually see what is needed, at least for me anyway