Julie has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Files used in class with answers
Hi,
I am missing some of the files used in class. Please could these be sent to me - Jens class (13&14Mar). I need solutions too.
practice variables, practice loops, practice functions and personnel record.
Many thanks
Julie
RE: files used in class with answers
Hi Julie,
I hope that you enjoyed my course.
Please find attached folder with the missing files.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
Attached files...
Excel VBA.zipRE: files used in class with answers
Hi Jens,
I have been doing the practice functions solutions but can only get the shipping total to run. The discount based on customer average does not work as I get the message "this function takes no argument,formula result = " when i go to pick up the user defined function, so I cannot select the customer average.
Also the raise one gets the same result. I am sure I got these to work in class. I have been recreating the files under a module but still cannot get the original solutions to run.
Is there something else I need to add such as declaring variables or something else. I am using excel 13.
Thanks
Julie
RE: files used in class with answers
Hi Julie,
I am sorry that you cannot get the functions to work.
I have tested the functions in Excel 2013 and I didn't get any errors.
If you get the message "function takes no arguments" it can have something to do with the name of the functions or which add-ins installed on your computer.
Try to copy below functions and paste the functions in Excel module in a new Excel workbook. See if you get the same error message.
Please let me know if the problem continue
Function ship(total)
ship = total * 0.14
End Function
Function disc(cust_average)
If cust_average > 20000 Then
disc = 0.08 * cust_average
ElseIf cust_average > 15000 Then
disc = 0.035 * cust_average
ElseIf cust_average > 10000 Then
disc = 0.01 * cust_average
Else
disc = 0
End If
End Function
Function NewSalary(salary, hire_date)
NewSalary= salary + (((Date - hire_date) / 365) * 150)
End Function
I hope it will work for you.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
RE: files used in class with answers
Hi Jens,
I followed your suggestion and it worked. There is a disc() in excel2013 which could have been the problemor I had stored it in the workbookand not the module.
Thanks
Julie
I have just done the vat calc one too, adding a loop to work down the lines.
RE: files used in class with answers
Hi Jens
Please could you also send me practice decision solution.
Many thanks
Julie
RE: files used in class with answers
Hi Julie,
Please find attached file "practice decision solution".
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
