Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Programming
Invalid qualifier with dates
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Basta1980, post: 13385253"] Hi all, Trying to create an userform. I'm testing if the userform works accordingley, needless to say it doesn't. Below is the code I use. Thing is I always get an 'invalid qualifier' when it comes ot fields containing dates (i.e. tbCreationDate). What do I have to do get these dates working?! Private Sub CommandButton2_Click() Dim tbCreationDate As Date Dim TB2ndcheck As Date Dim tbFinConDate As Date Dim tbMgt As Date Dim tbRetour As Date Dim tbGroup As Date Dim tbCFOCEO As Date Dim tbRetourCompleet As Date Dim tbVerwerktSystemen As Date 'Determine next empty line NewRow = Worksheets("Operational Credit").Range("A20000").End(xlUp).Row + 1 'Fill in data Worksheets("Operational Credit").Cells(NewRow, 1).Value = tbAanvrager.Value Worksheets("Operational Credit").Cells(NewRow, 2).Value = tbVeroorzaker.Value Worksheets("Operational Credit").Cells(NewRow, 3).Value = tbMinuten.Value Worksheets("Operational Credit").Cells(NewRow, 4).Value = tbBedrijf.Value Worksheets("Operational Credit").Cells(NewRow, 5).Value = tbBan.Value Worksheets("Operational Credit").Cells(NewRow, 6).Value = tbBedrag.Value Worksheets("Operational Credit").Cells(NewRow, 7).Value = tbCreationDate Worksheets("Operational Credit").Cells(NewRow, 8).Value = cbOorzaak.Value Worksheets("Operational Credit").Cells(NewRow, 9).Value = tbCorrectieActie.Text Worksheets("Operational Credit").Cells(NewRow, 10).Value = cbCheckFC.Value Worksheets("Operational Credit").Cells(NewRow, 11).Value = TB2ndcheck.Value Worksheets("Operational Credit").Cells(NewRow, 12).Value = tbFinConDate.Value Worksheets("Operational Credit").Cells(NewRow, 13).Value = tbMgt.Value Worksheets("Operational Credit").Cells(NewRow, 14).Value = tbRetour.Value Worksheets("Operational Credit").Cells(NewRow, 15).Value = tbGroup.Value Worksheets("Operational Credit").Cells(NewRow, 16).Value = tbCFOCEO.Value Worksheets("Operational Credit").Cells(NewRow, 17).Value = tbRetourCompleet.Value Worksheets("Operational Credit").Cells(NewRow, 18).Value = tbVerwerktSystemen.Value Worksheets("Operational Credit").Cells(NewRow, 18).Value = tbOpmerkingFC.Text tbAanvrager.SetFocus End Sub Regards, Basta [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Programming
Invalid qualifier with dates
Top