I have a UserForm in which RowSource is a Defined Name from a Table Column (IDX). I can enter the Defined Name: nSht3IDXArray and the ComboBox initially accepts the Values (1,2,3,,,,).
When a new row, with the next numerical sequence, is entered, the Defined Name variable will not update or refresh for sometime. At some point it does, but haven't quite figured out what sequence in needed for this to occur. Maybe it's closing the UserForm and reopening it, but there would have to be another method to refresh a Defined Name for a control on a UserForm. I have even tried refreshing the Defined Name, but it seems to have no effect on the ComboBox.
Has anyone experienced this with Excel 2007 or with Defined Names used as a RowSource?