Resetting combo boxes to a default value

  • Hello again


    I am attempting to build a model. The user makes several selections via various combo boxes [placed in different columns]. I want to give the user to flexibility to reset a group of combo boxes. e.g


    Reset combo boxes in row 1- Row 1 has combo 1 ,3,8,9 10.


    I am also attaching an excel file to be more clear.


    The reset button [reset c-01 in file] should reset the value of combo boxes [criteria 01 in file] to the first value in the source-list feeding each combo box/drop-down.


    I am a novice and tried searching through the forum but couldnot understand the complex examples. If someone can guide me with some code, it will be great


    Any insight will be appreciated.


    Thanks and regards
    Vikas

  • Re: Resetting combo boxes to a default value


    Hi Vikas,


    I can not tell whether the combo boxes are from the Control Toolbox or Form toolbox.
    This should deal with the Control Toolbox types.



    I'm sure there is a better way of referencing the controls but for the moment I can't think of it...

  • Re: Resetting combo boxes to a default value


    Andy


    Thanks for the quick reply. I apologize for the confusion.


    a) Combo boxes are from Form toolbox.
    b) I believe that the code suggested will reset all combo boxes in the model
    [correct me if I am wrong]. I want the user to be able to use the Reset C-
    01 button in the attached excel file to reset just the criteria 01 combo
    boxes and not affect the other combo-boxes.



    It will be great if you could guide me. Thanks again for being so considerate and for your time


    Vikas

  • Re: Resetting combo boxes to a default value


    Andy


    I am attaching the file with the layout.


    -Reset C-01 Should reset Drop down 200,7,8,9,10. They are placed in the
    row 3 from column D to I.
    -Reset C-02 Should reset Drop down 11-16. They are placed in the row 4.
    -Reset C-03 Should reset Drop down 17-22. They are placed in the row 5.
    Thanks again for your patience and consideration


    Vikas

  • Re: Resetting combo boxes to a default value


    Assign this macro to the 3 commandbuttons.
    Depending on the buttons caption the linked cells will be set to 1, which will reset the dropdown controls.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!