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".
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?
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!
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!
Exercise Files: learnitanytime.com/p/exercise-files-excel-2021-vba-intermediate-tutorial
@59:43 some things are unclear. Is variable LastCell supposed to be a range of cells, or one cell only? The instructor contradicted herself.
Hi, Can you share the ppt used for the VBA trainings?
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?
U have to first watch beginners video
There she made a macro enabled version of vehicles
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!
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
I'm still getting an error, any solution?
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.
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!
The singular form of 'Parentheses' is 'Parenthesis', not 'Parenthesy'
Thanks for correcting that for us!
Can there be a course made to automate SAP using VBA??????
its easy though
We will definitely look into it!
Thanks a lot for your great service. Please teach us about website creation and designing in wordpress.
Great suggestion!
Gr8
Thanks!
Hi
Hello!