Problems with custom Excel 2013 user form populating the spreadsheet.

I am building a QC tool and have a user form with a calendar select field, three combo boxes and two text entry fields.  Only the calendar populates to the correct cell.  I'm a newbie to VBA and can't figure out how to get the data from the Data Entry Form to the spreadsheet.  

The file is attached
QCSurvey.xlsm
ReverendJimAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
Your control names are wrong

Private Sub cmdadd_Click()
Dim erow As Long
With Sheet2
erow = .Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

.Cells(erow, 1).Value = Me.frmmachine.Text
.Cells(erow, 2).Value = Me.frmtime.Text
.Cells(erow, 3).Value = Me.tbplan.Text
.Cells(erow, 4).Value = tbactual.Text
.Cells(erow, 5).Value = frmcause.Text
End With

End Sub

Open in new window


Use names that indicate what type of control they are, not frmmachine, but cboMachine, tbxPlan.

Be wary of ActiveX calendars and date controls they will not work on all versions of Excel. There are non ActiveX examples here
Declare your varianles
ReverendJimAuthor Commented:
Thanks for the quick response Roy.  I have read over it and am having trouble understanding because I've never done this before.  It's a foreign language to me.  I'll take some time with it and let you know how I've made out.
Roy CoxGroup Finance ManagerCommented:
Just post back for help with what you don't understand.

Most important did you understand why the form wasn't working as you expected?

Have a look at the DatabaseForm example here. It's a free download and should help you learn more.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ReverendJimAuthor Commented:
Roy:
Thank you for your help so far.  I have decided to withdraw (or delete) the question because it's more complicated than it needs to be.  I have gone with dropdown selections directly in the spreadsheet for the user.  This is only an interim solution until I purchase a full-up manufacturing system that will track machine up-time automatically without a need for user audits.

Thank you again.
Roy CoxGroup Finance ManagerCommented:
It's not complicated at all. I corrected the errors in your code,.
ReverendJimAuthor Commented:
I've requested that this question be deleted for the following reason:

I found a less complicated solution - simply adding dropdown boxes directly to the spreadsheet.  With only a few columns of data, this is quite simple.
Roy CoxGroup Finance ManagerCommented:
I answered the question as posted, i.e the OP had use the wrong names for the Controls on the UserForm. His solution has nothing to do with his question

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.