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.

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

    MainForm.SystemNum.RowSource = "List"

    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

Participate now!

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