MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Add COUNT result to Titlebar

  Asked By: John    Date: Oct 19    Category: MS Office    Views: 1075

I have a COUNT function on one column in a spreadsheet.
I's like to display the total in the Titlebar.
How can I use VBA to modify the titlebar?



2 Answers Found

Answer #1    Answered By: Niran Jainukul     Answered On: Oct 19

The following code adds the document path to the title bar, I believe
you could modify  it to add  whatever you want it to.

Sub AutoOpen()
'Displays the Document Path in the Title Bar
ActiveWindow.Caption = ActiveDocument.FullName
End Sub

Answer #2    Answered By: Femke Bakker     Answered On: Oct 19

Another example:

Sub Test()
cap = InputBox("Enter Caption:")
ActiveWindow.Caption = cap
End Sub

Didn't find what you were looking for? Find more on Add COUNT result to Titlebar Or get search suggestion and latest updates.