Forum Discussion

Bruce1951's avatar
Bruce1951
Copper Contributor
May 31, 2020
Solved

Status Bar Count from a Macro

I have created a macro in Excel 2019 that presents the answer (Count) in the status bar at the lower left corner of the spreadsheet, (example 24 of 145 records found). The answer is correct. I would ...
excel
  • mtarler's avatar
    mtarler
    Jun 01, 2020
    Your very welcome, glad it helped. Please mark as answered to close the thread.
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jun 01, 2020
Name a cell as "ResultCell" then lets say the count value created in you macro routine is called FoundCount then add a line of code at the end saying Range("ResultCell").value = FoundCount
  • Bruce1951's avatar
    Bruce1951
    Copper Contributor
    Jun 01, 2020

    Wyn Hopkins 

     

    Hi Wyn,

    Thanks for the info. Unfortunately I am not knowledgeable enough to do what you are suggesting.

     

Resources