ComboBox Source Errors

Copper Contributor

Please ca n someone provide a sample of how to populate source information into a combobox in a User Form. I have tried the following:


1) Via Properties (eg Sheet1!M3:M11) in either Row Source or Control Source

2) By using VBA Code


Option 1) brings up an error window whilst Option 2) causes the code to fail at the "Open Form" module.


What is frustrating is that I am trying to populate the CB properties in a new User Form / New File exactly as in other recent files but now Excel will not allow this proerty to be completed.

0 Replies