Hi Currently i have a form Which has three combo box .then i have a search button which runs a query based on the values selected in the three combo boxes and shows the results in a list box below.see the image for the form here.

Now i want to add a button called "Export to excel" which will export the list box results to a Ms-excel sheet.how to go about doing this in vba. i have gone through threads related to this same issue but unfortunately none of them works ....kindly help

Now i want to add a button called "Export to excel" which will export the list box results to a Ms-excel sheet.how to go about doing this in vba. i have gone through threads related to this same issue but unfortunately none of them works ....kindly help