how can i submit data of my user form to an another excel sheet(User Details(Sheet1)

[tiger123]

i have created an userform

in userform i have Employee Name -- lbl2
current date ----lbl4
current time ----lbl6
project name----txt2
user comment---txt3

and a submit button

how can i submit the details to an particular excel sheet

Private Sub cmdbt1_Click()MsgBox "welcome to bms"
End Sub

Please help me out

 

[VoG]

Try like this

Private Sub cmdbt1_Click()
MsgBox "welcome to bms"
Sheets("Sheet1").Range("A1").Value = lbl2.Caption
' and so on
End Sub

 

[My Aswer Is This]

I'm surprised your using a listbox for current date and time. I would think you would use a text box. A listbox is used when you have a list of items to choose from.

 

[VoG]

I'm surprised your using a listbox for current date and time. I would think you would use a text box. A listbox is used when you have a list of items to choose from.

I assumed that was a label, not a listbox.