Announcement

Collapse
No announcement yet.

15 USD - Userform to be circulated as Add-In so others could use it.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 15 USD - Userform to be circulated as Add-In so others could use it.



    Hi,

    The attached userform allows to hide and unhide sheet based on a list box, can someone guide me how to create an add-in for the userform and circulate this to others.
    Attached Files

  • #2
    Hi,

    It is not clear to me why you would need an add-in ...

    However, if you are looking for a good explanation ...

    You can take a look at : https://www.jkp-ads.com/articles/buildexceladdin.asp

    Hope this will help
    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment


    • #3
      step - 1 save as as EXCEL.ADDIN (XLAM)
      step - 2 Select file goto Option select Quick acces toolbar select choose command from --select macro - select your macro names has save as xlam - click add
      now in your toolbar has instal your add in clik and run


      Click image for larger version

Name:	aaa.png
Views:	1
Size:	47.9 KB
ID:	1211770

      Comment


      • #4
        Originally posted by Carim View Post
        Hi,

        It is not clear to me why you would need an add-in ...

        However, if you are looking for a good explanation ...

        You can take a look at : https://www.jkp-ads.com/articles/buildexceladdin.asp

        Hope this will help

        if i want others to use the Sheet filter, how else do you think this can be circulated?

        Comment


        • #5
          Originally posted by graha_karya View Post
          step - 1 save as as EXCEL.ADDIN (XLAM)
          step - 2 Select file goto Option select Quick acces toolbar select choose command from --select macro - select your macro names has save as xlam - click add
          now in your toolbar has instal your add in clik and run


          Click image for larger version

Name:	aaa.png
Views:	1
Size:	47.9 KB
ID:	1211770

          When I try to do this, I'm getting debug error

          Attached Files

          Comment


          • #6
            Do not know your constraints and your objective ...

            if i want others to use the Sheet filter, how else do you think this can be circulated ?
            Are you trying to design a Generic Sheet Filter ?

            Most probably your users are manipulating different workbooks .. which do not have an identical structure ...

            As a consequence, the Show / Hide process would need to be customized ...

            If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

            Comment


            • #7
              Originally posted by Carim View Post
              Do not know your constraints and your objective ...



              Are you trying to design a Generic Sheet Filter ?

              Most probably your users are manipulating different workbooks .. which do not have an identical structure ...

              As a consequence, the Show / Hide process would need to be customized ...
              Hi Carim,

              Yes, I'm trying to design generic sheet filter that everybody can use. When I save this as an Add-In and try to open the worksheet I get the debug error on the following code

              Function IndicatedSheet(Index As Long) As Worksheet
              If -1 < Index And Index < ListBox1.ListCount Then
              Set IndicatedSheet = CurrentBook.Sheets(ListBox1.List(Index, 0))
              End If
              End Function

              Comment


              • #8


                Hello,

                Have you tried to replace CurrentBook by ActiveWorkbook ...

                HTH
                If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

                Comment

                Working...
                X