Make List Box Interactive

Is there any way that you can make a List Box interactive on the VBA Forms so that you can change the data in the list box and it updates the spreadsheet?

Mandi

Sounds possible. We will need more details of your problem.

I have a multipage set up and within the Multipage is a list box with 10 columns (which is in fact the spreadsheet that is imported). I have created a macro that runs and checks a number of the fields and where a field is in the incorrect format, this field is displayed as being incorrect. What I would like to be able to do is change the data within the field from the list box, rather than going back to the imported spreadsheet. My only other option was to have the spreadsheet available at the bottom of the form, but I presume that this would need to be done via an OLE Object and I do not know how to do this.

Your assistance with any ideas would be appreciated.

Thanx in advance,
Mandi