Hi,
I have built an Excel (Personal Account dealing approval request) form which is used by circa 600 individuals based across the UK and Europe to submit PA dealing requests.
A number of the cells (share price, total consideration, etc.) have conditional formatting to automatically select £ or € depending on which country the individual is in. This works well, except when an individual in e.g. the Netherlands is buying a share that is denominated in a currency other than €. Basically, the conditional formatting does not allow the user to simply key in e.g. £1,500 - it then changes it back to €1,500...
In short, I would like the cell(s) to default to the 'home' currency of the user, but to allow the user to key in an amount in a different currency and have the cell automatically change to that currency format (most likely to be £ or $).
Clearly the individual could manually use the formatting button at the top - but I was hoping to find a way for the cell currency format to simply update dynamically.
There is plenty of VBA running behind the scenes to route the requests to different approvers and capture relevant details in a register behind the scenes - so maybe someone has come across some simple VB code that I can customise...
Thanks in advance for any suggestions.
Bcfaigg
I have built an Excel (Personal Account dealing approval request) form which is used by circa 600 individuals based across the UK and Europe to submit PA dealing requests.
A number of the cells (share price, total consideration, etc.) have conditional formatting to automatically select £ or € depending on which country the individual is in. This works well, except when an individual in e.g. the Netherlands is buying a share that is denominated in a currency other than €. Basically, the conditional formatting does not allow the user to simply key in e.g. £1,500 - it then changes it back to €1,500...
In short, I would like the cell(s) to default to the 'home' currency of the user, but to allow the user to key in an amount in a different currency and have the cell automatically change to that currency format (most likely to be £ or $).
Clearly the individual could manually use the formatting button at the top - but I was hoping to find a way for the cell currency format to simply update dynamically.
There is plenty of VBA running behind the scenes to route the requests to different approvers and capture relevant details in a register behind the scenes - so maybe someone has come across some simple VB code that I can customise...
Thanks in advance for any suggestions.
Bcfaigg