Mar 21 2023
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.