Help needed, data input

[Johncanty85]

Hi all, was hoping someone could offer some advice/help. Trying to devise a way of logging payments using a simple userform. I was hoping to have individual sheets for individual jobs with a dropdown on the userform correlating to each sheet - hope is that user would have to select job title/sheet name from a drop down menu, input a brief description and a total and that would then pre populate the next available cell in the relevant column.. Not sure if what I'm describing is possible but I would really appreciate any pointers any one could offer as not very well versed in vda.. Thanks in advance

 

[My Aswer Is This]

Well you did not say what this means:
You said:

pre populate the next available cell in the relevant column

What is the relevant column?

This script here will load all the sheet names into Combobox1 which is on your Userform.

Then you enter data into Textbox1 and Textbox2

Then press Command button1
​

The script will enter the data that's in Textbox1 and Textbox2 in columns A and B of the sheet you selected from the Combobox

If this is not what you want we need more specific details.

Put this script in your Userform.

Private Sub CommandButton1_Click()
'Modified  12/9/2018  5:59:57 PM  EST
Dim Lastrow As Long
Dim ans As String
ans = ComboBox1.Value
Lastrow = Sheets(ans).Cells(Rows.Count, "A").End(xlUp).Row + 1
Sheets(ans).Cells(Lastrow, 1).Value = TextBox1.Value
Sheets(ans).Cells(Lastrow, 2).Value = TextBox2.Value
End Sub
Private Sub UserForm_Initialize()
'Modified  12/9/2018  5:59:57 PM  EST
Dim i As Long
    For i = 1 To Sheets.Count
        ComboBox1.AddItem Sheets(i).Name
    Next
End Sub