Posts by XCage

    Hi
    I am writing code for a quote systems with various Userforms. On UF3 I have a few checkbox and then dependent on is checked a few dropdown boxes will appear as visible or not on UF4.
    I need to know how I can display 2 of them that will be True and appear as visible?


    Private Sub UserForm_Initialize()


    If Use_AI = True Then
    UF4_Module_Selection.AI_Combo_Channel.Visible = True
    UF4_Module_Selection.AO_Combo_Channel.Visible = False
    UF4_Module_Selection.DI_Combo_Channel.Visible = False
    UF4_Module_Selection.DO_Combo_Channel.Visible = False
    End If


    'not working
    If Use_AI = True And Use_AO = True


    UF4_Module_Selection.AI_Combo_Channel.Visible = True
    UF4_Module_Selection.AO_Combo_Channel.Visible = True
    UF4_Module_Selection.DI_Combo_Channel.Visible = False
    UF4_Module_Selection.DO_Combo_Channel.Visible = False


    End If

    Hi,


    I have a Userform with 2 columns, 1st Column is the checkbox with various items, (Fans, Bulbs, Desks etc..) then next to it a Textbox with the Heading - Quantity, the idea is to make the user tick the box if applicable and indicate the number of items required. How can I use the code to make the name/Caption of the checkbox appear in the Excel sheet or cell?


    Thank you

    Hi Everyone


    I am relatively new to VBA.
    I have an User form that will be designed to create a quote. It has multiple sheets in the background. The user will select the various options for the project.
    I am struggling to create the form so that when they select option button 1 then the combo box populates with certain data, when the select combo box 2 it populates with other data etc...
    Thinking If statement would be the best..


    If OptionButton1 = True Then
    'ComboBox3.Rowsource=Worksheets("Sheet2").Range(C2:C5)


    Can anyone guide me in the right direction?