Hello. I am using this code to populate the list range in my combo box (ActiveX Controls). It seems to be working great except for that once the spreadsheet is closed, the data in the list disappears. In order to repopulate the list, the user has to rerun the macro. Is there anyway to get around this issue?
Thanks in Advance!
Please Login or Register to view this content.
Last edited by alrichar; 12-13-2012 at 03:52 PM.
You are populating the combobox with code, so you would need to run the code again to populate the combobox.
You can populate the combobox through the combobox properties, and enter the range in "ListFillRange".
Check out
http://support.microsoft.com/kb/830287 , to find out how to use dynamic ranges.
Another option would be to run the code when you open the workbook.
Last edited by davesexcel; 12-14-2012 at 05:38 AM.
Thanks for the help. I tried that route but for some reason I wasn't getting the result that I was looking for. The data in the combo box is text, so I am not sure if that has anything to do with that.
I went with an Auto Open macro that seems to fix this issue for the time being.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks