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.
Don’t have an account yet? Register yourself now and be a part of our community!