View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default use ComboBox value to select range and then use selected range to create a chart

Jerry formulated the question :
Your code works fantastic, thank you so much for your awesome help, I
really appreciate it!


You're welcome! ..always glad to help!


Don't mean to be greedy, I wonder how to integrate your code with the
code (if needed) in my original file to create the chart with 3 series
(H3351, H3335, S3521) in it. I know it may be very easy, but I'm not
sure how to do so, as I'm a total VBA newbie (you may have figured it
out right after you saw my original post).


I did not go there because I rarely use charts. You can turn on the
macro recorder and see what generates while you do it manually, then
clean the resulting code up for reuse. I'll help you with that if you
post the code generated by the macro recorder.

Good luck...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc