Thread: How do I set the rowsource for a ComboBox for a dynamic list?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ndm berry[_2_] ndm berry[_2_] is offline
external usenet poster
  
Posts: 13
Default How do I set the rowsource for a ComboBox for a dynamic list?
I have a ComboBox on a UserForm that relates to a list which is updated every
time the workbook is opened. At the moment, so that I can carry on with
other aspects, I have set the rowSource as follows:-

ComboBox1.RowSource = "A1:B456"

This of course is only temporary and I would appreciate a more permanent
solution.

Many thanks in advance.
Reply With QuoteReply With Quote