HI, Here is the required macro to search a field and if value found copy the whole row into another...
I found a solution like this :Records in between two specific dates easily can be filtered using drop-down lists ....
I found a solution as follows: Watch the video to see how it's done and download example file : https://youtu.be/SZduAoOtiS0
I have sorted the above problem. Code is given below... [code] Sub seperate() Call CleanSheets MsgBox "1 of 10 Cleaning...
Hi, Here is the VBA code to Split the Workbook into different Files by Each Sheet in the file and...
Hi, You can loop through the Sheet using Workbook Sheets Collection. See the Updated Code below: [code] Sub sbDeleteRows() 'Array...
Hi, We can follo several methods to fill the unique values from the worksheet to ListBox. Here is my preferred...
I am looking for VBA code to for Filling a Listbox on Excel User-Form with Unique Values from Worksheet.
I have string values in a column. Some of them are repeats. I just want unique values as the source for the combo box please.
Thank you Raghu
We can follo several methods to fill the unique values from the worksheet to ListBox.
Here is my preferred method to add unique values from worksheet to list box. This example macro will read the data from active worksheet from column A and Fill the unique strings into list box. You can use this code for both List box and Combo Box.
Private Sub UserForm_Initialize()
strCol = "A" 'Column number
lRow = 10 'Last Row with Data
For iCntr = 1 To lRow
nLookUp = Application.WorksheetFunction.CountIf(Range(strCol & "1:" & strCol & iCntr), Range(strCol & iCntr))
'Add Only First Occurance
If nLookUp = 1 Then ListBox1.AddItem Range(strCol & iCntr)
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).
Enter the destination URL
Or link to existing content