listbox problem

I have listbox on a userform with number and the way it should work is that when I click on a number in listbox the data correspond to this number should be copied from one sheet to another sheet and gets plotted on graph. The problem is when I click on a number in the list box the data moves from one sheet to another and get plotted but only after I exit the userform sheet. I want all this done while the userform still open is there something I am doing wrong? Any help is appreciated. the file is too big to attach.

Thanks

Hi,

Difficult to comment without sight of the workbook. Any chance of cutting out most of the records, just leaving a sample and attaching here.

Is it a ListBox from the Excel Forms toolbar, or an ActiveX ListBox driven by the Visual Basic Environment?

Can you post the macro that's attached to the ListBox, and any macros attached to any of the Worksheet events, i.e. Change, Selection_Change, DeActivate etc.

Rgds

I cute out most of the data but the code is little large so the file size is still 210kb. Do you have an email I can send it to you?

Thanks

Hi,

If you zip that file it should reduce it below the 100Kb limit so that you can attach it. Just right click on the file name in Windows Explorer and choose the zip option. If you still have problems post back and I'll PM my email address.

Rgds

I already zipped it and still large also I need to attach another file where the data get copied from. So there is two files.

Hello wlaid66,

Try seeting your UserForm.ShowModal property to False. This will enable you to work in Excel while the UserForm is displayed.

Sincerely,
Leith Ross