Hi,
I'm very new to this and an struggling to get my first userform working.
I have built the form and inserted various combo boxes and list boxes but I cant seem to get the results from these boxes to carry over into my main code. for example what I have at the moment is:
Private Sub Accounts_Change()
Dim acc As Integer
acc = Me.Accounts.Value
Worksheets("sheet1").Cells(17, 10).Value = Accounts.Value

End Sub
This stores the result in Acc (and pastes it into a cell) but when I try to use the variable acc later in my code it is always empty.

What am I doing wrong !!