Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Y or N option to print 1 of 2 schedule
Hi,
In Excel, I would like to be able to have a cell that will print 1 of 2 schedules depending on whether we insert a 'Y' or a 'N' A 'Y' inserted would print say schedule 1 and a 'N' will print schedule 2. We already have a script that has a button that will print a number of schedule that we run from, so will be able to add to this, hope this is enough information. -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Y or N option to print 1 of 2 schedule
Sub printoneortwo()
Range("scd" & InputBox("enter 1 or 2")).PrintPreview End Sub -- Don Guillett SalesAid Software "sjf0464 via OfficeKB.com" <u28215@uwe wrote in message news:684070c6cd15a@uwe... Hi, In Excel, I would like to be able to have a cell that will print 1 of 2 schedules depending on whether we insert a 'Y' or a 'N' A 'Y' inserted would print say schedule 1 and a 'N' will print schedule 2. We already have a script that has a button that will print a number of schedule that we run from, so will be able to add to this, hope this is enough information. -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Y or N option to print 1 of 2 schedule
Sub printoneortwofromcell()
Select Case LCase(Range("c1").Value) Case "y": ms = 1 Case "n": ms = 2 Case Else End Select ActiveSheet.Range("scd" & ms).PrintPreview End Sub -- Don Guillett SalesAid Software "sjf0464 via OfficeKB.com" <u28215@uwe wrote in message news:684070c6cd15a@uwe... Hi, In Excel, I would like to be able to have a cell that will print 1 of 2 schedules depending on whether we insert a 'Y' or a 'N' A 'Y' inserted would print say schedule 1 and a 'N' will print schedule 2. We already have a script that has a button that will print a number of schedule that we run from, so will be able to add to this, hope this is enough information. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing: how do I amend my print defaults? | Excel Discussion (Misc queries) | |||
Print separate reports with same column heading | Excel Discussion (Misc queries) | |||
Conditional formats don't print | Excel Discussion (Misc queries) | |||
Checkboxes vs. Option Buttons | Excel Discussion (Misc queries) | |||
Urgent Help required on printing option | Excel Discussion (Misc queries) |