Results 1 to 3 of 3

Thread: ComboBox Array

  1. Jan 17th, 2005, 05:08 AM #1
    [nordis]
    [nordis] is offline

    Thread Starter
    New Member
    Join Date
    Jan 2005
    Location
    Sandviken Sweden
    Posts
    2

    Question ComboBox Array

    Hi All
    I've been trying to populate a combobox with an array of all the month of the year, but with no luck.
    There is probably a simpel task if you know how
    I'm doing this in Excel 97 and I would like to use VBA rather than a cell range.
    All help are appreciated
    Thanks
    Last edited by [nordis]; Jan 17th, 2005 at 06:59 AM.
    Reply With Quote Reply With Quote
  2. Jan 18th, 2005, 01:20 PM #2
    Comintern
    Comintern is offline
    Fanatic Member Comintern's Avatar
    Join Date
    Nov 2004
    Location
    Lincoln, NE
    Posts
    826

    Re: ComboBox Array

    Try this, where ComboBox1 is your control:

    VB Code:
    1. For iCount = 1 To 12

    2.     ComboBox1.AddItem (Format$(DateAdd("m", iCount, 0), "mmmm"))

    3. Next iCount
    Reply With Quote Reply With Quote
  3. Jan 24th, 2005, 01:09 PM #3
    [nordis]
    [nordis] is offline

    Thread Starter
    New Member
    Join Date
    Jan 2005
    Location
    Sandviken Sweden
    Posts
    2

    Re: ComboBox Array

    Thanks Comintern
    I'll try that
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width