Announcement

Collapse
No announcement yet.

Combobox RowSource not updating

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

  • ape
    started a topic Combobox RowSource not updating

    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.

  • ape
    replied
    Thanks, it was an excel issue.

    Leave a comment:


  • rory
    replied
    To update it, you need the name of the range in quotes:

    Code:
    MainForm.SystemNum.RowSource = "List"

    Leave a comment:

Working...
X