4.5 Using Complex Macros with Real-Life Problems Part 4
8 hours 33 minutes
So we're continuing the conversion.
or visual basic macros that are needed for this.
then this by calling opening the message box and saying, Imperial instead of that,
you're just going to call.
So if it's imperial, we have to change it to metric, and we're going to call Imperial
metric, we're going to call
You don't actually have to match these cases here, but it looks nicer if you type it properly
and we're going to save this.
And now let's do our conversion.
Let's see if everything is working.
We're just going to assign macro to it
and it's going to be the decide one.
And now we're going to click on it.
and it works. So we gave us a mounted leaders. We click again.
It brings us back
the unit's imperial units.
this is it. You see, the answers have been changed to grams
and milk chocolate
units, which were also ounces. Have we changed the grams
and we're getting here.
shop not, sir. Now in leaders,
this might be a problem because in metric recipes we do have
transfer these thes thes products are given in Graham's not in Liters.
However, it would be really complicated to have for every different product conversion, so we're just going to keep it like this. So this way
we have created successfully a button within this sheet and we can copy between worksheets. So if you have more recipes, we can just
copied this button. We just have to keep the comparison chart sheet in
the Excel file, and it will work perfectly every time, so escorted back to Imperial and close this
part of this listen.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand