VBA to show pop up box to select data range for double bar chart

  • Hi

    This is probably a very simple answer, but beyond my very limited knowledge of VBA/macros

    I recorded the macro below to show this stage in its simplest form. This is what it records if I perform the range selection manually. However I want to replace this manual range selection with a pop up to select the data during part of a larger macro.

    Many thanks in advance for any light that you can shed on this.

    Kind regards

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!