Need to Add VBA Code to Write Response to Listbox in Current Table

In the attached file I need to have the user respond before moving to the next record.  If the listbox is not complete I need a message that the user must respond before proceeding to the next record.  After use has made a listbox selection, i need the code to write the selection to column six in the current row.

Thank you!!!
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:

What do you mean by complete? No missing entries on the line? If so then try this
Sub WriteToSheet()

    Dim oCtl As MSForms.Control
    For Each oCtl In Me.Controls
        If TypeName(oCtl) = "TextBox" And oCtl.Value = Empty Then
            MsgBox "There are missing entries. Please complete"
            Exit Sub
        End If
    Next oCtl
    With Me
        rData.Cells(lRw, 2).Value = .tbxAssessText.Value
        rData.Cells(lRw, 3).Value = .tbxSubcat.Value
        rData.Cells(lRw, 4).Value = .tbxMaturity.Value
        rData.Cells(lRw, 5).Value = .tbxDecstate.Value
    End With
End Sub

Open in new window

mcarsonsrAuthor Commented:
Hi Roy,

In column six of the data tables I need to add a Yes/No/N/A response from the user to each record.  The response should then be written to the table. The user is responding to the declarative statement.  I have added the Listbox, but I do not know how to code it, using the obviously very advanced coding techniques you use.  I am not sure this appropriate on this forum, but may I send you a private message about an arrangement for you to help me further for a fee?
Roy CoxGroup Finance ManagerCommented:
I'm not sure how that works either. Depending on the amount of work I will be happy to help, if it's not much then a small donation to a charity that I will suggest. Otherwise, we will need to find out what to do according to the rules here.

What you need should be doable

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.