Transfer data from userform to spread sheet in excel

[mmix803]

I am new to VBA and userforms. I cannot get my userform to transfer to my worksheet. This is what I have. I did little steps to see if it would go. It did not. Please help.

Private Sub submitcmd_Click()

Dim invoicedate As Date
Dim invoicenumber As Long

Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Invoice")

Dim nextRow As String
nextRow = ws.Range("A" & Rows.Count).End(xlUp).Row + 1

ws.Range("A" & nextRow) = invoicedatetxt.Value
ws.Range("B" & nextRow) = invoicenumbertxt.Value


End Sub

 

[Logit]

I did not understand you already had a means to open your user form. You can delete the following from the code and instructions that I
previously posted.

In this version I inserted a CommandButton on the userform (UserForm1) and the button's name is CommandButton1.

In a regular module paste the following :

Code:
Option Explicit

Sub shwFrm()
UserForm1.Show
End Sub

On the worksheet "Invoice" paste a CommandButton and attach it to this macro (shwFrm).

 

[mmix803]

Sorry it did not work and I double checked all. I even tried a command button of the spread sheet it did not work.

 

[Logit]

Can you post your workbook (no confidential information please) to a cloud website so we can download it and see what is going on ?

Post the link to the workbook here.

 

[abdelfattah]

So you should attach file using dropbox or onedrive web to see your problem .

 

[mmix803]

Sorry for everything. I work in Access and love it. To me it is easier. I am only doing this in excel for my son. Access is not available on a mac computer. I have built a very nice data base and he can not use it . I use it and that because I do his books.

 

[mmix803]

I made a totally different sheet and it worked. Thank you for all your help and putting up with me. many thanks again.

 

[Logit]

Glad you have an answer. Cheers !

 

[abdelfattah]

Good news.
Just change mark solved to Post #7 that I gave you the code,if it's work for you.