Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User form caption automatically populate with excel file name
I have a workbook that I do frequent updates to. Each time I do an
update I add an increment to the number in the filename with a "save as". (i.e. Daily Report 3.x) The workbook contains a splash screen which displays for a few seconds when it opens (userform). Is to possible for the caption in this userform to automatically grab the file name ? It would save me a few minutes each time I update it. Thanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User form caption automatically populate with excel file name
If your UserForm is called UserForm1, use
Private Sub Workbook_Open() UserForm1.Caption = ThisWorkbook.Name End Sub in the ThisWorkbook code. Steve wrote: I have a workbook that I do frequent updates to. Each time I do an update I add an increment to the number in the filename with a "save as". (i.e. Daily Report 3.x) The workbook contains a splash screen which displays for a few seconds when it opens (userform). Is to possible for the caption in this userform to automatically grab the file name ? It would save me a few minutes each time I update it. Thanks, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User form caption automatically populate with excel file name
Thanks JakeyC ... works perfectly !
Steve JakeyC wrote: If your UserForm is called UserForm1, use Private Sub Workbook_Open() UserForm1.Caption = ThisWorkbook.Name End Sub in the ThisWorkbook code. Steve wrote: I have a workbook that I do frequent updates to. Each time I do an update I add an increment to the number in the filename with a "save as". (i.e. Daily Report 3.x) The workbook contains a splash screen which displays for a few seconds when it opens (userform). Is to possible for the caption in this userform to automatically grab the file name ? It would save me a few minutes each time I update it. Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Caption controls beyond formatting | Excel Programming | |||
Can I have a user form with no Header/Caption Bar ? | Excel Programming | |||
User form - Picture in the caption? | Excel Programming | |||
Excel VBA - User form caption problem | Excel Programming | |||
Automatically including the Form and Code in all the user file | Excel Programming |