Posts by ItsSugarBunny

    Hello can anyone help, im trying to figure out a formula for this, lets say i have worksheet A and B, if the value in column A worksheet A equal to the value in column A worksheet B, then the result will be "TRUE" in column B worksheet B. BUT if the value is NOT EQUAL the result will be "FALSE" in red color. what formula should i put in column B worksheet B ?

    Hello can someone help me with vba code, let's say I have a sheet with 2 columns. If 1st cell in column A is blank, i want to automatically copy 1st cell in column B and paste it in 1st cell in column A, etc, BUT if cells in column A is NOT blank, i want to keep column A with the current data. DO I even need vba code to do this? :D
    ANY and all help is GREATLY appreciated. tHANKYOU ^^

    hello, can someone help me with the code to deselect all option button in a userform after submit (using commandbutton) the data.
    so, i have a userform with 2 option button inside, lets say i submit the first data with optionbutton1 selected, and without closing the userform i want to submit another data without optionbutton1 nor optionbutton2 selected. what is the code for it? THANKYOU IN ADVANCE! :)
    like in another case for example, in TEXTBOX, to make the textbox remain blank after submit a data without closing the userform you give code under cmbsubmit_click event likewise : txtName= " ". So the textbox will be blank after you click submit button. i wonder when it comes to option button, the code would as simple as that

    Hi, can anyone help me with the below...

    Im looking for a vlookup formula which will give me the MAXIMUM number from a list different worksheet which contains multiple matches, i.e.

    Lookup number 1 from column A, then give me the largest number from column B

    example table:
    A B
    1 5
    2 2
    1 11
    3 2
    4 5

    the result would be 11:
    A B
    1 11

    And i currently use this formula in destination cells:
    i use" IFERROR" to turn "#VALUE!" into blank cell
    thanks all!

    hello can someone help me with the code how to remove duplicates from dropdown list combobox? i need the additional code for preventing the duplicates from the dropdown list. because this code lists the whole data without removing the duplicates. i attach the example file below

    Private Sub ComboBox1_Change()
    Dim i As Long
    With Me.ComboBox1
    If Not IsArrow Then .List = Range("AccountsList").Value
    If .ListIndex = -1 And Len(.Text) Then
    For i = .ListCount - 1 To 0 Step -1
    If InStr(1, .List(i), .Text, 1) = 0 Then .RemoveItem i
    Next i
    End If
    End With
    End Sub

    Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    IsArrow = KeyCode = vbKeyUp Or KeyCode = vbKeyDown
    If KeyCode = vbKeyReturn Then Me.ComboBox1.List = Range("AccountsList").Value
    End Sub