Consulting

Results 1 to 3 of 3

Thread: Solved: Delete gaps in a combobox

  1. #1

    Solved: Delete gaps in a combobox

    Hi, I have a combobox on a userform which appears with gaps in the dropdown list - is there a way I can get rid of the gaps?
    The code I have to get the dropdown list is:

    [VBA]

    Me.ComboBox2.List = Worksheets("QuestionSet2").Range("a1:a25").Value
    [/VBA]

    Anyone got any ideas? Thanks

  2. #2
    Not sure why you marked the thread as solved... In any case this is an Access forum and your question is an Excel question.

  3. #3
    Thanks MacroShadow. I did realise I'd posted to the wrong forum, but didn't seem to be able to delete the post, so as an alternative I marked it solved, so that people didn't waste their time reading it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •