Selective values to fill combobox

**sabrinamay16** · 12-27-2012, 12:41 PM

I need to show values in combobox that have no values to the left of them. It is a calendar with dates as the first column and then either events or blanks in the next column. For my form I want only the dates with blanks to show in the combobox. So far I have this code, but I'm having trouble adding a loop as it makes excel crash. I would then need code to input an event to the sheet next to a date (I have added a textbox to the form to do this). This is my code so far:

Please Login or Register  to view this content.

Please help!

**xladept** · 12-27-2012, 03:26 PM

Maybe:

Please Login or Register  to view this content.

**sabrinamay16** · 12-28-2012, 09:45 AM

Doesn't work

Only shows one value with a blank next too it, doesnt show the rest

**xladept** · 12-28-2012, 02:07 PM

What do you get for the

Please Login or Register  to view this content.

when you single step through??

**sabrinamay16** · 12-28-2012, 02:10 PM

I've stepped through it and it doesnt loop at all, goes through it fine without errors but doesnt try to go back to the top.

**xladept** · 12-28-2012, 02:21 PM

If it doesn't work that way - maybe:

Please Login or Register  to view this content.

**sabrinamay16** · 12-28-2012, 02:38 PM

it works!!! but is only displaying 18 dates free when there are over 100...

**xladept** · 12-28-2012, 03:59 PM

What does it show for

Please Login or Register  to view this content.

if it shows the actual last row number then it's not the problem I think it is - why don't you try it with the actual last row number? And, if it works - we'll need to find another way to code for the last row??