Hi! Great job! But some common VBA mistake at 15:10. If you declare like this: "Dim Var1, Var2, Var3 As String", only the last variable Var3 will have a String type. The others will be a Variant! You could execute Debug.Print TypeName(Var1) to make sure of it. You should declare like: "Dim Var1 As String, Var2 As String, Var3 As String".
Not sure if I'm too late to the party, but is there a Power Point that I'm not seeing? I'd love to see the actual deck so I can take notes at my own pace!
Unfortunately it seems that the video gets lost at 37:38. It refers to a macro-enabled version of the Vehicles file which isn't in the associated file pack (as pointed out by another user). Also the video refers to a column called Status which isn't in the Vehicles spreadsheet and which hasn't yet been created by the tutor. This is a shame as the tutorial was going well till then. Does anyone have a solution to this confusion?
Solved. In Sub GetNewInventory i didn't put VinNumber, only write VinNum. I still curious why in this sub i need to write the whole VinNumber rather than just short it, but the code will not work if i put on VinNum
Hi! Great job!
But some common VBA mistake at 15:10. If you declare like this: "Dim Var1, Var2, Var3 As String", only the last variable Var3 will have a String type. The others will be a Variant! You could execute Debug.Print TypeName(Var1) to make sure of it.
You should declare like: "Dim Var1 As String, Var2 As String, Var3 As String".
Thanks for the info!
Great pace and presentation of topics!
Thanks!
Not sure if I'm too late to the party, but is there a Power Point that I'm not seeing? I'd love to see the actual deck so I can take notes at my own pace!
Exercise Files: learnitanytime.com/p/exercise-files-excel-2021-vba-intermediate-tutorial
This is great but I don't think the exercise files are accurate esp for the "Vehicles". Can you please update it with the correct file? Thanks.
The singular form of 'Parentheses' is 'Parenthesis', not 'Parenthesy'
Thanks for correcting that for us!
Hi, Can you share the ppt used for the VBA trainings?
@59:43 some things are unclear. Is variable LastCell supposed to be a range of cells, or one cell only? The instructor contradicted herself.
Unfortunately it seems that the video gets lost at 37:38. It refers to a macro-enabled version of the Vehicles file which isn't in the associated file pack (as pointed out by another user). Also the video refers to a column called Status which isn't in the Vehicles spreadsheet and which hasn't yet been created by the tutor. This is a shame as the tutorial was going well till then. Does anyone have a solution to this confusion?
Thanks a lot for your great service. Please teach us about website creation and designing in wordpress.
Great suggestion!
Please where can I get the slides used for the lessons?
The vehicles file isn't xlsm, so I can't see the programs you're referring to during half the video 😕
Thank you I appreciate it a lot
You're welcome!
Can there be a course made to automate SAP using VBA??????
its easy though
We will definitely look into it!
1:41:09 i got an error on here where my Classmarker was read as string but in "If" was read as Integer, so it didn't match the function. Any solution?
Solved. In Sub GetNewInventory i didn't put VinNumber, only write VinNum. I still curious why in this sub i need to write the whole VinNumber rather than just short it, but the code will not work if i put on VinNum
Gr8
Hi
Hello!