Custom function in a status bar

  • Hello. friends.


    I have a column with the following details:


    Month
    ------
    JAN
    FEB
    FEB
    JAN
    MAR


    As you see appear just 3 months.
    When I select this range aboth, I want to show "3" in a status bar. Is any way to do this?


    If it impossible, what the effective macros to show it in a message box?


    Thanks

  • Re: Custom function in a status bar


    here's one way, assuming Range B2:B10 contains your list, this will place the number of unique ites in A1 then in the Statusbar


  • Re: Custom function in a status bar


    royUK,


    A2:A10 is a static range, how to define in this formula the following range:
    #
    Range("A2").Select
    Range(Selection, Selection.End(xlDown)).Select
    #
    I put "selection" in a formula but it doesn't work.

  • Re: Custom function in a status bar


    Do you mean like this

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!