Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview in loop
Hi Group,
Having trouble to get below code to execute as I hoped. If more then one selection is made in the listbox I was hoping there was possible to loop true the print previews and printout or close the preview, and that next selection should show as print preview. I get only this working for one selection, if more the loop stops. Grateful for some hints how to get the loop running, Best regards CG Rosen ----------------------------------------------------------------------------------------------------------------- For i = 0 To Me.ListBox1.ListCount - 1 If Me.ListBox1.Selected(i) = True Then Sheets("print").Cells(6, 2) = Sheets("Sheet3").Cells((Me.ListBox1.List(i, 4)), 1) Sheets("print").Cells(7, 2) = Sheets("Sheet3").Cells((Me.ListBox1.List(i, 4)), 2) Application.Dialogs(xlDialogPrinterSetup).Show UserForm1.Hide Application.Visible = True ActiveSheet.PrintPreview EnableChanges:=False Application.Visible = False UserForm1.Show End If Next i |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview in loop
Seems to me you should pull the UserForm1.Show out of the loop.
-- Jim "CG Rosen" wrote in message ... Hi Group, Having trouble to get below code to execute as I hoped. If more then one selection is made in the listbox I was hoping there was possible to loop true the print previews and printout or close the preview, and that next selection should show as print preview. I get only this working for one selection, if more the loop stops. Grateful for some hints how to get the loop running, Best regards CG Rosen ----------------------------------------------------------------------------------------------------------------- For i = 0 To Me.ListBox1.ListCount - 1 If Me.ListBox1.Selected(i) = True Then Sheets("print").Cells(6, 2) = Sheets("Sheet3").Cells((Me.ListBox1.List(i, 4)), 1) Sheets("print").Cells(7, 2) = Sheets("Sheet3").Cells((Me.ListBox1.List(i, 4)), 2) Application.Dialogs(xlDialogPrinterSetup).Show UserForm1.Hide Application.Visible = True ActiveSheet.PrintPreview EnableChanges:=False Application.Visible = False UserForm1.Show End If Next i |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) |