Visual Basic (VB and VBA)

Copyright 1999-2001 Christopher Greaves. All rights reserved. Home Page and email to [email protected]

If in doubt, record a macro and inspect the entrails!

Here is an INDEX to all the procedures.

You will probably need one copy of my GLOBAL DECLARATIONS.

Public Function strSetCaption(str As String) As String
' Procedure :   strSetCaption
' Description:  Change the contents of the application title bar.
' Copyright: Chris Greaves Inc.
' Inputs:       A string.
' Returns:      String being the previous caption.
' Assumes:      None.
' Side Effects: The title bar will change.
' Tested:       By the calls shown below.
    strSetCaption = Application.Caption
    Application.Caption = str
'Sub TESTstrSetCaption()
'    MsgBox strSetCaption("99!")
'End Sub
End Function

We all knew nothing when we started …

Home Page and Contact Information Send email to [email protected]. This page was last updated Thursday, November 15, 2001

Visual Basic (VB and VBA)

Copyright 1999-2001 Christopher Greaves. All rights reserved. Home Page and email to [email protected]

If in doubt, record a macro and inspect the entrails!

Here is an INDEX to all the procedures.

You will probably need one copy of my GLOBAL DECLARATIONS.

Public Function strSetCaption(str As String) As String
' Procedure :   strSetCaption
' Description:  Change the contents of the application title bar.
' Copyright: Chris Greaves Inc.
' Inputs:       A string.
' Returns:      String being the previous caption.
' Assumes:      None.
' Side Effects: The title bar will change.
' Tested:       By the calls shown below.
    strSetCaption = Application.Caption
    Application.Caption = str
'Sub TESTstrSetCaption()
'    MsgBox strSetCaption("99!")
'End Sub
End Function

We all knew nothing when we started …

Home Page and Contact Information Send email to [email protected]. This page was last updated Thursday, November 15, 2001