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

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 sample data attached 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.

DUDE! This is absolutely perfect - thank you so so so much.

I was asked to do this for my manager at work and had no idea how to proceed.


Thanks again!