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.

 

[My Aswer Is This]

Cells(1,12)

Means:

Row(1) of Column(12)


What do you mean when you say you found 66

Do you mean you found a value in column L

If that is the case then that may have caused a problem
Make sure column L which you said you did not have any thing in does not have any thing in it when you start the script.

 

[My Aswer Is This]

Why do you have 66 in column B

Is that suppose to be there?

That is not a name

 

[ipbr21054]

No
Forget that as it will complicate things.
All values are names.

When i look up Run time error 70 it is when a file is trying to be renamed etc / protected.

So can you tell me at what point the code is now when it crashes.

 

[ipbr21054]

Sorted.

There was a Row Source code on the userform.

Norie mentioned something about this today on another post so i thought i would check it out & now working fine.

Many thanks for all the help you give me today & other times.

have a nice day

 

[My Aswer Is This]

The code works for me.
I'm not able to tell you where the script crashes when it does not crash for me.
Do you have any protected Ranges?

 

[My Aswer Is This]

Sorted.

There was a Row Source code on the userform.

Norie mentioned something about this today on another post so i thought i would check it out & now working fine.

Many thanks for all the help you give me today & other times.

have a nice day

Yes I mentioned way earlier to not use row source. So I assumed you had removed it from the Properties box

Well glad it's working now.

So are you now saying all is working

 

[ipbr21054]

Yes all working now.

When you mentioned Row source i removed all the code from the Comboboxes but wasnt that on another post ?

Anyway all done thanks very much.

 

[My Aswer Is This]

Glad all is working now. Take care.

Yes all working now.

When you mentioned Row source i removed all the code from the Comboboxes but wasnt that on another post ?

Anyway all done thanks very much.

 

[strooman]

Yes I mentioned way earlier to not use row source.

It's not a problem to use the RowSource property but NOT in combination with the .list command because this causes a conflict. RowSource provides the data for the combobox (and is hard-coded in the properties list on the lower left). Therefore an Error 70: "Permission Denied".
In the same time the combobox should be populated with the .list command. Excel, VBA (or whatever) gives the priority to the RowSource property. Solution -> Clear the RowSource (or don't use the .list command).

 

[My Aswer Is This]

The user wanted the Range as dynamic. Like when you add more values to a range.
Row Source is not dymamic or if it is I do not know how to make Row Source Dynamic

It's not a problem to use the RowSource property but NOT in combination with the .list command because this causes a conflict. RowSource provides the data for the combobox (and is hard-coded in the properties list on the lower left). Therefore an Error 70: "Permission Denied".
In the same time the combobox should be populated with the .list command. Excel, VBA (or whatever) gives the priority to the RowSource property. Solution -> Clear the RowSource (or don't use the .list command).