Cop/Paste data from Combobox

[JAN01]

Is it possible to copy & paste the data from a combo box?

I have an excel document that contains a macro to copy/paste/e-mail a single worksheet within a workbook, but it does not copy the combobox.

Any suggestions?

 

[SkipVought]

Hi,

What is your procedure actually doing?

Please post your code.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[JAN01]

The procedure is as follows:--

An excel workbook that contains multiple pages that contain orderforms.

Once the orderform has been completed a macro button is pressed to enable the newest orderform to be copied into a new workbook and then e-mailed for ordering.

All information is copied except from a combo box that is in the original workbook.

The macro is as follows:-

Sub email_page()

'
Cells.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWindow.DisplayGridlines = False
Application.Dialogs(xlDialogSendMail).Show
End Sub


I hope I have explained it okay!

 

[SkipVought]

Well, INSTEAD of copying the COMTENTS of the sheet, COPY the SHEET.

    ActiveSheet.Copy
    Application.Dialogs(xlDialogSendMail).Show

ought to do it for you.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[JAN01]

Thanks Skip!

Sometimes you just can't see the wood for the trees!!!