Search box on userform

[ipbr21054]

Morning,

I have a userform with a Combobox which is populated from customers names from my POSTAGE worksheet.
I would like to select a customers name from the list & then be taken to that customer on my worksheet.
Currently my worksheet is sorted by date example A8 01/10/2015 to current info cell A646 30/10/2018
This then means that the customers names in column B are not in any order.

This is how it should work.
Sort ComboBox names A-Z
Browse through the list & select a customer.
Upon selecting a customer close userform
Then that customer is selected on my worksheet.

Here is some information to assist you.

Worksheet is called POSTAGE
Customers name will always be in column B
The range is B8 & onwards
The userform is called PostageTransferSheet
The Combobox is called CustomerSearchBox

Thanks & have a nice day.

 

[ipbr21054]

@MAIT
I have been playing with this new code and it works well.
I have noticed that i need to apply something for duplicated customers or more than 1 customer with the same name.

I have now started a new post for this.
Thanks.

 

[My Aswer Is This]

@MAIT
I have been playing with this new code and it works well.
I have noticed that i need to apply something for duplicated customers or more than 1 customer with the same name.

I have now started a new post for this.
Thanks.

I see no new posting.

So what is your plan now
How do you plan to deal with Duplicate name?
See that is why people should always be identified by Company id number or such.

 

[ipbr21054]

I will need to have a code that when I type in a cell in column B alert me if there is a match.
So if I am alerted that Tom Jones exists I can then enter the new Tom Jones like Tom Jones2 etc.

Then when I use the new code that we made earlier I can select any Tom Jones and see every record.

I can’t add a user ID for customers as they are not staff etc.

 

[ipbr21054]

Not sure what happened there but just did another one.
It is called "Code to stop duplicate entries"

Thanks

 

[My Aswer Is This]

To find all your duplicates in column B
Run this script
It will color every cell Green if its a duplicate

Sub Color_Duplicates()
'Modified  10/4/2018  12:57:18 AM  EDT
Application.ScreenUpdating = False
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "B").End(xlUp).Row
Dim Rng As Range
Dim c As Range
Set Rng = Range(Range("B1"), Range("B" & Rows.Count).End(xlUp))
    
    For Each c In Rng
        If WorksheetFunction.CountIf(Rng, c.Value) > 1 Then c.Interior.ColorIndex = 4
    Next
Application.ScreenUpdating = False
End Sub

 

[ipbr21054]

Morning,
I did a similar thing last night and renamed all of the duplicate names.
Now all the names in my sheet are unique.

Need to now start work on the code which checks as i press the click to transfer button.
This was a new post, Did you see it ?

Thanks

 

[My Aswer Is This]

I saw a posting about search for duplicate values Yes.
And some users were saying you should do things differently
I did see you put in your script

TextBox1.Value = Now

And then formatted as date.
As I had suggested Date

Now gives date and time
As Date gives just Todays Date
I don't understand why you want Now but then format it as only date.

But hey it's your script.

It looks like this script has something to do with Ebay

I would think if customers are using this to order items each customer at the beginning would be given a Account number.

I'm sure Ebay does not search for customers by name. They would maybe have thousands of users with same name.
​

 

[ipbr21054]

Hi,
I have the date thing now sorted.

This post is now finished.

Forget the ebay thing as you are going off track a bit.
This form is to keep a register of where the item was sold,dont read to much into this please.

Now i started a new post late last night where i required the following code,please take a look for this new post.

When a member of staff uses your new code on the POSTAGE sheet i do not want duplicate entries on the sheet.
So i need to overcome that, So this new code will run when i either press the transfer button or after i type the customers name & then click in the next text box the code will then run 7 check to make sure that customer does not exist on my sheet.