Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I set an InputBox default value to the active worksheet's LeftHeader?
More infor - if needed: ================ I have a workbook with several worksheets. Each sheet has the same page setup except for the LeftHeader. Instead of using FilePageSetup on every sheet I select each sheet then run a macro that uses an InputBox to prompt for the LeftHeader and reset it. This works OK except the InputBox value is initially <blank What I would really like to do is to set the InputBox default value to the existing LeftHeader value. This way I don't have to re-type the header in full when, for example, I only want to correct a spelling mistake. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
setting up a inputbox with a number value | Excel Worksheet Functions | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Setting LeftHeader / CenterHeader | Excel Programming | |||
Get header only on first page of multi page excel file | Excel Discussion (Misc queries) | |||
Language portability problems when setting LeftHeader text from external app (=non-VBA) | Excel Programming |