Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DIALOG BOX DEFAULT LABELS
How can I modify this macro to default to the last label typed for
this input box? I only need to be able to override it, so I don't need to re type it every time I run it. Sub header() Period = InputBox("What Period?") DivName = InputBox("What Division?") title1 = InputBox("CENTER TITLE ROW 1") title2 = InputBox("CENTER TITLE ROW 2") With ActiveSheet.PageSetup .LeftHeader = Period & Chr(10) & DivName .CenterHeader = title1 & Chr(10) & title2 .RightHeader = Date .RightFooter = page End With End Sub Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DIALOG BOX DEFAULT LABELS | Excel Programming | |||
specify default path in dialog open box | Excel Programming | |||
print dialog box with 2 copies as default? | Excel Programming | |||
new dialog box-Change default display | Setting up and Configuration of Excel | |||
GetOpenFilename Dialog default path | Excel Programming |