Macro Button With Embedded Variables

[Forex-Forex]

Dear Excel Community

Attached is a macro that Pierre Leclerc help create. I need the following modification please

◘On the Analysis Tab, can we in Column I have an embedded table that will allow us to change the parameters in the macro:

Please Login or Register  to view this content.

I may need to change the 1000 or 0.01 easily to other numbers so if I change the parameters and click RUN Button it will update the Analysis Tab

◘Also have a RUN Button to have this working work
[/COLOR]
Thanks a million

[patel45]

see attached file

[Forex-Forex]

Patel45

Thanks for doing this. There is an issue with the file in that if I enter a country in the Data tab and click Run it picks the country - that is OK

However, if I then delete the country and click Run, it still appears in the Data tab

Please see attached file in that I entered Mauritius and then deleted it, but it still appearing

Thanks

[patel45]

I'm sorry but I solved the parameters problem, I don't know the goal of your macro

[HaHoBe]

Hi, Forex-Forex,

However, if I then delete the country and click Run, it still appears in the Data tab

There is no deleting of the old result on Sheet Analysis which will feature that behaviour for sure: starting on Row 3 the new data will be transferred and overwrite existing data but not take care to delete the old one.

Please Login or Register  to view this content.

@patel45

I don't know the goal of your macro

You donīt need to, you just should have deleted Mauritius on Sheet "Data" and looked at the results on Sheet "Analysis" as TO has done.

Ciao,
Holger

[Forex-Forex]

Thanks everyone for the contributions