Printable View
I'm haveing problems creating a chart marker. I've done most of it see file.
What i wnat to do is edit the range of data by the date. It will make more sense when you look at the file. There are also comments in the file explaining what i want to do any help would be great. The comments are in the VBA code and on the worksheet. Also if the code in this file is helpful to anyone feel free to use it.
Pearso
Can I suggest that, rather than asking the user for the dates via Inputboxes - which are difficult to control, validate, etc. - you could:
1/ add two additional controls, either listboxes or comboboxes to your form.
2/ populate those controls with the values in row"1", the colum headings.
3/ use the values of those controls to define your range.
Thanks for that i'll give it a go. I don't think i'm doing to bad for my first attempt at writing VBA code. If i have any problems i'll post a revised copy.
Cheers,