4.5 Using Complex Macros with Real-Life Problems Part 4

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9
Video Transcription
00:00
So we're continuing the conversion.
00:02
Yeah,
00:03
process
00:05
or visual basic macros that are needed for this.
00:09
And here
00:11
we have
00:12
then this by calling opening the message box and saying, Imperial instead of that,
00:19
you're just going to call.
00:23
So if it's imperial, we have to change it to metric, and we're going to call Imperial
00:30
two Metric.
00:33
And here
00:35
if it's
00:37
metric, we're going to call
00:41
metric.
00:43
Sorry
00:46
to Imperial.
00:50
You don't actually have to match these cases here, but it looks nicer if you type it properly
00:56
and we're going to save this.
00:59
Close it.
01:00
And now let's do our conversion.
01:03
Let's see if everything is working.
01:07
We're just going to assign macro to it
01:12
and it's going to be the decide one.
01:17
And now we're going to click on it.
01:19
Sorry,
01:22
and it works. So we gave us a mounted leaders. We click again.
01:26
It brings us back
01:29
the unit's imperial units.
01:32
So
01:33
this is it. You see, the answers have been changed to grams
01:38
and milk chocolate
01:40
units, which were also ounces. Have we changed the grams
01:44
and we're getting here.
01:47
Ah,
01:48
shop not, sir. Now in leaders,
01:49
this might be a problem because in metric recipes we do have
01:55
transfer these thes thes products are given in Graham's not in Liters.
02:04
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
02:15
we have created successfully a button within this sheet and we can copy between worksheets. So if you have more recipes, we can just
02:24
copied this button. We just have to keep the comparison chart sheet in
02:30
the Excel file, and it will work perfectly every time, so escorted back to Imperial and close this
02:40
part of this listen.
Up Next