Announcement

Collapse
No announcement yet.

Combobox RowSource not updating

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

  • Combobox RowSource not updating



    I have combo box (SystemNum) in form "Mainform1" with RowSource set to "List" a dynamic variable set up in Name Manger (.List = OFFSET(storage!$U$12,0,0,COUNTA(storage!$U:$U),1) The changes in "List" only show when the macro is restarted! I have tried a few thing and a few hours with no outcome!!
    I have also tried below;
    Set RowSource blank in properties
    Refresh RowSource after event " MainForm!SystemNum.RowSource = List "
    This shows a blank list
    Any help would be appreciated.

  • #2
    To update it, you need the name of the range in quotes:

    Code:
    MainForm.SystemNum.RowSource = "List"
    Rory
    Theory is when you know something, but it doesnít work. Practice is when something works, but you donít know why. Programmers combine theory and practice: nothing works and they donít know why

    Comment


    • #3


      Thanks, it was an excel issue.

      Comment

      Working...
      X