Forum Discussion

Denny57's avatar
Denny57
Copper Contributor
Mar 21, 2023

ComboBox Source Errors

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.

No RepliesBe the first to reply

Resources