title: Setting the controlsource value of a listbox using Properties Window
body: <p>I am new to VBA and am currently still studying the most basic ideas of the language. I haven't gotten that far in my VBA Code studies to write the code I need by hand, so, in the mean time, I have been using the VBA Editor to enter Property Values via the Properties Window. This has been proving far more difficult than I anticipated. My Goal is to create a drop down list for a VBA Form. I understand one of my options is to reference a range of cells in my excel worksheet by inputting it into the value field located right of the ControlSource Property. My attempts to input the desired range always comes up with the same error:</p>
  
  <p><strong>Could not set the ControlSource Property. Invalid Property Value.</strong></p>
  
  <p>I have tried looking in the VBA Help files and even searched online. I haven't had any luck finding the proper syntax to enter into this field.</p>
  
  <p>I am assuming I may run into similar issues as I try to set other property values through the Property Window. Thus, I am diligently studying my VBA courses so I can simply write the raw code. But that takes time and I need this form to work as soon as possible.</p>
  
  <p>Is there anyone out there that wouldn't mind lending me their brain for a moment? I would be most grateful. Having this working would bring a lot of stress off of me.</p>
  
  <p>Thanks for reading!</p>