Results 1 to 9 of 9

Thread: populate control from named range stored in addin

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Member
    Join Date
    Jul 2013
    Posts
    40
    Rep Power
    0

    Cool An example of what I mean

    I have attached a similar far simpler file that is reproducing the issue mentioned above.

    In procedure UserForm_Initialize of Form UserForm1 I get
    Error 380 (Could not set the RowSource property. Invalid property value. )

    The problem is here:
    Code:
    ComboBox1.RowSource = ThisWorkbook.Names("myTypes")
    Even if I could bypass it using On Error statements it will occur again in ComboBox1_Change when I populate ListBox1 in a similar manner.

    I am guessing that I am not referring properly to the named ranges stored in the add-in.
    Perhaps because it is an add-in.
    However, if I change the IsAddin to False in ThisWorkbook Properties, then the ComboBox and the ListBox will populate with no error at all.

    BTW you can also access the form using the ribbon button I created so as to be closer to the original file where the issue appeared.

    Thanks again for your interest and help...
    Attached Files Attached Files
    Last edited by MrBlackd; 05-07-2016 at 10:46 PM. Reason: provide detailed description and attachment
    Keep in mind all vba I know has been googled...

Similar Threads

  1. setting loop code to check all named sheets
    By peter renton in forum Excel Help
    Replies: 9
    Last Post: 01-30-2014, 03:01 AM
  2. Replies: 15
    Last Post: 01-07-2014, 12:42 AM
  3. Replies: 4
    Last Post: 07-02-2013, 11:32 AM
  4. Populate data in form
    By Ryan_Bernal in forum Excel Help
    Replies: 4
    Last Post: 02-01-2013, 10:18 AM
  5. Replies: 4
    Last Post: 06-07-2012, 09:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •