sheet1.cellsi

Hi Team, Is there a way to shorten this code used in if condition. If Sheet1.Cells(i, 1).Value = "Green" Or Sheet1.Cells(i, 1).Value = "Red" Or Sheet1.Cells(i, 1).Value = "Blue" Then like If Sheet1.Cells(i, 1).Value = Array("Green", "Red", "Blue") Then Thanks in advance Regards, mg

Hi everybody, I'm still trying to wrap my head around the idea of 'early' and 'late' binding and I couldn't understand it. I've looked up on google but I don't know how to apply to my code. Basically, I started looking for solutions when I created a shared file but people using different...

HI, i have the code below, how can I change it that I can search for either the Vendor name or code cells (the two cells in green?. here is the code: Private Sub SearchButton_Click()Dim totRows As Long, i As Long totRows = WorksheetFunction.CountA(Range("A:A")) If VendorTextBox.Value = ""...

Hi I have created a userform in excel, where you can look a specific ID number up and through that update the specific information connected to the number. My problem is that I can't figure out how to get my checkboxes to update the value in the specific row with it being marked with an X or...

Hello, I am trying to modify the code below to copy only visible cells and paste it in the specific destination on another sheet. How would I modify the code below such that if I apply a filter to Sheet1, the data pasted into Sheet2 will be only the visible Cells? Thanks in advance for all the...

Hi, there is something that I can't figure out in this code, Sub test() Dim i As Integer Dim diff05 As Double diff05 = 0.8 For i = 2 To 4 If Sheet1.Cells(i, 2).Value >= diff05 And Sheet1.Cells(i, 2).Value < diff05 + 0.05 Then Sheet1.Cells(i, 11) =...