+ Reply to Thread
Results 1 to 3 of 3

Dependant Combobox in userform

  1. #1
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Dependant Combobox in userform

    Hi people,

    I would like to know how to do the following:

    i have a small userfrom called "FrmInd" and 2 comboboxes "CBman" & "CBSpec"
    i want to make the CBSpec combobox depandant on the CBman combobox contents.

    here is the code i have so far:

    Please Login or Register  to view this content.
    For somereason when i select a name in the CBMan box the CBSpec box still won't populate?

    Cheers for reading guys and girls
    Last edited by VBA Noob; 09-20-2007 at 11:21 AM.
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    The code you have to CBSpec comboboxes will have to be placed in the CBman click event (or whatever). It can't fill it at form initialize as there hasn't been a selection made from CBman at that stage.


    HTH

    rylo

  3. #3
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Talking Thanks

    Hi buddy,

    thanks for the help, i did initially try tjat but i know realise that using this line of code is not possible in this instance:

    Please Login or Register  to view this content.
    Instead you must split that code into:

    Please Login or Register  to view this content.
    I'm sure you know this anyway but thought it was worth posting!!

    Cheers folks

+ Reply to Thread

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