Currency Exchange rate are now dynamically extracted at run time with the new enhancements of the stocks data type.
In this project we combine some of the best Excel tools in building a Live currency converter: Power Query, Data Validation, Vlookup Function, Macro Recording, Stocks Data Type and Worksheet Events.
You can download the start file and follow along by clicking on the link:
[ Ссылка ]
Jump to a specific Topic on the Timeline:
Get & Transform with Power Query 1:57 min
Create Data Validation Lists 5:01 min
Create VLOOKUP Functions 6:07 min
Record a Macro for Stocks Data Type 7:50 min
Attach the Macro to the Change Event 12:47 min
Edit the Macro in VBA 15:28 min
In this tutorial I will be writing a very simple code and attach it to the worksheet event. Should you wish to copy that code, here it is:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("A2").Address Or Target.Address = Range("B2").Address Or Target.Address = Range("C2").Address Then
Call Convert
End If
End Sub
If you found value in this tutorial, give it a thumb up and subscribe to my channel to be notified when new videos are released.
Music Credit :
Electro Cabello by Kevin MacLeod is licensed under a Creative Commons Attribution license ([ Ссылка ])
Source: [ Ссылка ]
Artist: [ Ссылка ]
Ещё видео!