JZB
08-21-2009, 12:54 AM
Hi Guys
I am producing a macro which will chart the performance of any individual the user chooses.
How do i create a pop up box at the start of the macro where the user can specify the name of the individual they wish to see a chart of?
Also how can i then make that answer my variable?
The rest of the macro is quite simple. Just using find the variable and then chart the range of offset cells.
Just stuck on this bit :banghead: .
Thanks
Jon
I am producing a macro which will chart the performance of any individual the user chooses.
How do i create a pop up box at the start of the macro where the user can specify the name of the individual they wish to see a chart of?
Also how can i then make that answer my variable?
The rest of the macro is quite simple. Just using find the variable and then chart the range of offset cells.
Just stuck on this bit :banghead: .
Thanks
Jon