Results 1 to 4 of 4

userform one combobox dependent on another

Threaded View

  1. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: userform one combobox dependent on another

    Do not use additem to populate a combobox or listbox

    This will be sufficient:
    Private Sub cboRoadway_AfterUpdate()
        cbostreet.list = sheets("Data").cells(1,1).offset(,cborailway.listindex+1).specialcells(2).value
    End Sub
    I suppose
    roadways in column A
    streets of first roadway in column B
    streets of second roadway in column C, etc.
    Last edited by snb; 07-06-2010 at 03:57 AM.

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