VBA or Form To Update Base Data

Good evening All,

Could someone kindly assist with ways on how to update base information in a model I am working on. I have attached a simulation of what the base information tab looks here: https://drive.google.com/file/…1bGNPZHM/edit?usp=sharing . This tab will be hidden, but I would like the master user to be able to update the base salaries which feed the rest of the model through other calculations.

Any ideas on how I could update this table, using some sort of code or form depending on which country's information I want to update.

All assistance appreciated

Many Thanks

H

Re: VBA or Form To Update Base Data

Quote from royUK;693052

Here's an example form that should get you started

UserForm Example

Also, see the DataBaseForm

Hi Roy,

This is absolutely awesome; I have never used input boxes before. What you sent through actually solves my exchange rate problem, but do not have the slightest idea what you did. Could you please point me to a tutorial.

The rest of the table is pay rates by grades from 72 to 77 by country. I need to be able to update these pay rates, say by selecting a country and then I have the option to ammend the pay rates from 72 to 77.

Really appreciate your help.

Thank you

Herbz

Re: VBA or Form To Update Base Data

Quote from royUK;693069

It's a UserForm not an InputBox. I'm at work to now but if I have time tonight I'll add some notes to the code. In the meantime maybe tried to understand the code which cab be easily adapted to do the rest

Thanks Roy, I will try and fiddle with it, but I am a bit of a novice when it comes to the whole area of coding. If you can spare a moment in the evening that would be fantastic, but no pressure.

Many Thanks

H

Re: VBA or Form To Update Base Data

Hi Roy,

Please accept my apologies for the late reply, I have been away from the office since late last week, and have only just come back in. I have looked at the user form you have designed, I am very impressed. Thank you so much for taking the time to look into this for me, I really appreciate your help. By the way which part of the UK are you in? I went to Leeds Business School in the North and stayed in the UK for about 8.5 years. As you can see from my location, I am now based back home in Southern Africa in Zimbabwe.

Much appreciated

Herbz

Re: VBA or Form To Update Base Data

Are you on skype by any chance?