Logo 
Search:

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: 673
  

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?

Share: 

 

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.




Tagged: