Results 1 to 4 of 4

Adding selections to combo box with VBA

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-26-2007
    MS-Off Ver
    2007
    Posts
    102

    Adding selections to combo box with VBA

    This should be very easy, but I am not getting it to work. I have a userform with a combo box and I just want to hard code the values to it in VBA. I want the value in the combo box to be 1 - 10. Here is what I have so far.
    Private Sub UserForm_Initialize()
    With ComboBox1
    .AddItem "1"
    .AddItem "2"
    .AddItem "3"
    End With
    End Sub
    For some reason I cannot get this to work. Any suggestions would be extremely helpful.

    Thank You!
    Last edited by jcarstens; 10-19-2009 at 01:10 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1