Can't get combo box in user form to populate

**KDrew** · 05-14-2015, 04:46 PM

Hi all,

I'm building a user form to input data to a sheet. Everything works except the combo box, which won't populate. I've tried the forums here, Microsoft help, and YouTube, but I can't find anything wrong with the methods I've tried. I'm pretty new at this, so it's probably some obvious difference between the instructions and my code that I'm not noticing. Here's my original code:

Please Login or Register  to view this content.

When this didn't work, I tried a different style:

Please Login or Register  to view this content.

I've placed this code in "ThisWorkbook" and the form code module and I've tried commenting out the list index line in case it was causing problems. No matter what I've tried, the combo box is always blank. Any suggestions?

**LJMetzger** · 05-14-2015, 05:17 PM

Hi KDrew and welcome to ExcelForum,

Thank you very much for using CODE TAGS.
Excellent job using 'Option Explicit'.

There is nothing wrong with your code. The problem is your spelling.

Try: Sub UserForm_Initialize()

In the future, I recommend two things:
a. Don't type in the names of UserForm routines. Let Excel do it automatically to prevent spelling errors.
b. If a routine doesn't seem to work, put a breakpoint on the routine in the debugger and single step through it. That's how I knew about the spelling error. The breakpoint I set never got triggered.

Here are a few debugger tips for the future:
Debugger Secrets:
a. Press 'F8' to single step (goes into subroutines and functions).
b. Press SHIFT 'F8' to single step OVER subroutines and functions.
c. Press CTRL 'F8' to stop at the line where the cursor is.
d. 'Left Click' the margin to the left of a line to set (or clear) a BREAKPOINT.
e. Press CTRL 'G' to open the IMMEDIATE WINDOW. 'debug.print' statements send their
output to the IMMEDIATE WINDOW.
f. Select View > Locals to see all variables while debugging.
g. To automatically set a BREAKPOINT at a certain location put in the line:
'Debug.Assert False'
h. To conditionally set a BREAKPOINT at a certain location put in lines similar to:
if i >= 20 and xTV20 > 99.56 then
Debug.Assert False
endif
i. A variable value will be displayed by putting the cursor over the variable name.

Lewis

**KDrew** · 05-14-2015, 07:09 PM

Lewis,

Thanks for the quick reply, that fixed it perfectly. Knew it was some stupid mistake. I did let Excel create the sub name, but I must have deleted the letter without noticing. I also ran through the first set of debugging tips but didn't understand what they were telling me. Appreciate the catch!