Creating a Dialog box using VBA that can be used to modify cell values

[wajyam]

Hi,

I have data with three variables (volume, price, revenue). I want to create a dialog box where the user can choose to modify an observation/cell value of their choosing by a certain percentage.

For example, if you look at the dialog box below I want to create a dialog box where I can select 'Australia' or any other region and 'Volume' or 'Price' and adjust by x percentage?

Thanks in advance.

 

[wajyam]

Meant to say 'For example, if you look at the dialog box *sample data below I want to create a dialog box where I can select 'Australia' or any other region and 'Volume' or 'Price' and adjust by x percentage?