Plotting data problem

[walid66]

I have this code but it only works on one selected number. If I pick any other number on the list box it does not plot the values. I know my problem is at this line Rows.select but I can't think of a solution for it. If this code can be simplified that would be great. Any help is appreciated.

Thanks

Please Login or Register  to view this content.

[mrice]

Try this

Please Login or Register  to view this content.

[walid66]

it works but there are couple of bugs. When I select 66 the macro selects 166and if I select 88 it selects 188 and so on. Also if the selected number has more than 5 entries the plot got missed up. For example 65 has five entries when i select the plot got missed up. thanks for your help.

[Andy Pope]

I assumed you only what the found member plotted.

Please Login or Register  to view this content.

Userform code

Please Login or Register  to view this content.

[walid66]

Andy,
what I want is left hand value in the listbox before "_" for example to 100 to match the left value on the sheet "FwdAvgPP%" in column a. If the left values matches I want to plot all the corresponding value. for example 100 has 4 corresponds I want to plot all of them at the same time. Not just one by one. Thanks for your help.

[Andy Pope]

Userform code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[walid66]

Thanks Andy, it worked perfectly.