Hi guys
A bit of a complex one (for me as a newbie anyhow) but I need a bit of help please.
I’m looking to create a pop up box with a drop-down menu containing the 12 months of the year (Jan, Feb, Mar, etc). This selection will determine which row values will be entered on my “ForEx” tab (e.g Jan - 3, Feb - 4, Mar - 5, etc).
Next, I want six pop up boxes to appear sequentially for CHF, DKK, EUR, NOK, PLN and USD respectively. In this box, the user should enter the exchange rate for each of those currencies to 1GBP.
Once entered, the values should go to the relevant line (using Jan as an example):
CHF – ForEx!I3
DKK - ForEx!J3
EUR – ForEx!K3
NOK – ForEx!M3
PLN – ForEx!N3
USD – ForEx!O3
I know this can be done because I’ve seen something similar, but I’ve not a clue where to start with this other than it would need to be done in VBA.
Any help would be much appreciated.
Thanks,
Gareth
A bit of a complex one (for me as a newbie anyhow) but I need a bit of help please.
I’m looking to create a pop up box with a drop-down menu containing the 12 months of the year (Jan, Feb, Mar, etc). This selection will determine which row values will be entered on my “ForEx” tab (e.g Jan - 3, Feb - 4, Mar - 5, etc).
Next, I want six pop up boxes to appear sequentially for CHF, DKK, EUR, NOK, PLN and USD respectively. In this box, the user should enter the exchange rate for each of those currencies to 1GBP.
Once entered, the values should go to the relevant line (using Jan as an example):
CHF – ForEx!I3
DKK - ForEx!J3
EUR – ForEx!K3
NOK – ForEx!M3
PLN – ForEx!N3
USD – ForEx!O3
I know this can be done because I’ve seen something similar, but I’ve not a clue where to start with this other than it would need to be done in VBA.
Any help would be much appreciated.
Thanks,
Gareth
