Form items chosen in Listbox to populate specific cells in spreadsheet

Hi
I am not a VBA expert but try change the problems code lines to the following:

ws.Cells(iRow, 5).Value = UserForm1.lbVeh.Value

Good luck.
Tony

What it is doing is putting whatever I pick in all five columns.

I am getting the data for the list from another sheet.
When I choose... let's say the third item down "Adobe Connect" - it then places "Adobe Connect" on all my columns E - I

I need to figure out how to associate them in the following way, so when one is chosen, it lands in the appropriate column.

Live Training - E
Live Workshop - F
Adobe Connect - G
Conference Call - H
Article - I

Hi
Try this:

With Data
If UserForm1.lbVeh.Value = "Live Training" Then
ws.Cells(iRow, 5) = UserForm1.lbVeh.Value
End If
If UserForm1.lbVeh.Value = "Live Workshop" Then
ws.Cells(iRow, 6) = UserForm1.lbVeh.Value
End If
If UserForm1.lbVeh.Value = "Adobe Connect" Then
ws.Cells(iRow, 7) = UserForm1.lbVeh.Value
End If
If UserForm1.lbVeh.Value = "Conference Call" Then
ws.Cells(iRow, 8) = UserForm1.lbVeh.Value
End If
If UserForm1.lbVeh.Value = "Article" Then
ws.Cells(iRow, 9) = UserForm1.lbVeh.Value
End If
End With

Hope this helps.
Good luck.
Tony

HOLY GOOD GOSH... That worked!!!

You have NO IDEA what a load off that is!!!

I have three of these types of boxes in my form and one of them has over 30+ items (which multiple items can be selected from).
Will this same type of code work for all of them?

THANK YOU!!!!

Just found out this doesn't work when I go to "Multi-Select"
NUTS!

Back to the drawing board!!!

Hi
Are you able to post a sample of your workbook so I can take a look for you.
Tony

I went about it a different way and was able to get it up and running.

Thank you so much for the help you gave me! Not only did you let me retain my sanity and look at it from a different perspective, but you also allowed me to see there were different ways I could accomplish what I was looking to do.

I really appreciate the help!

Thanks for the feedback.