Saladsamurai
02-08-2010, 11:06 AM
When you use the 'Chart Wizard' it gives the user the option of clicking on a little 'button thing' and then selecting the data range that they want to the chart to reference. It looks like this:
http://i12.photobucket.com/albums/a220/saladsamurai/promptything.jpg
Is there any way to mimic this in VBA? For example, let's say that I have a variable 'MyRange' I want to prompt the User to select a Range and then hit OK; then the selected range will be stored in the variable 'MyRange'
I have a feeling that I will need to use a UserForm for this.
Any ideas on how to mimic the prompt button or at least its functionality?
Thanks!!!
http://i12.photobucket.com/albums/a220/saladsamurai/promptything.jpg
Is there any way to mimic this in VBA? For example, let's say that I have a variable 'MyRange' I want to prompt the User to select a Range and then hit OK; then the selected range will be stored in the variable 'MyRange'
I have a feeling that I will need to use a UserForm for this.
Any ideas on how to mimic the prompt button or at least its functionality?
Thanks!!!