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?
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

your formula doesnt work in my workbook is it possible using my current formula? i just have no idea where im suppose to put "max" in my current formula.

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:
SHEETS1
A B
-----
1 5
2 2
1 11
3 2
4 5

the result would be 11:
SHEET2
-----
A B
1 11

And i currently use this formula in destination cells:
=IFERROR(VLOOKUP(A2;sheet1!$A$1:$B$1000053;2;);"")
i use" IFERROR" to turn "#VALUE!" into blank cell
thanks all!

HOLY! It works smoothlyyy thanks Master

[ATTACH=JSON]{"data-align":"none","data-size":"full","title":"vvv.jpg","data-attachmentid":1205981}[/ATTACH]i literally removed all my old code and replace with yours and i already changed the "combobox1" and the range tho. no error nor debug. it just didnt show any changes, no drop down list no debug no error

have u tried the code u write on the excel file attached? i have tried ur code but unfortunately it didnt work. Please help
could u write the code in excel file if u dont mind

how to remove my own post/question in this forum?????????

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
.DropDown
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

thanks! A lot this is what excatly im looking for. but how to remove duplicates from drop down list? can u please help add the code to remove duplicates?