Populating text boxes from a combo box choice

Hi All,

I am trying to populate text boxes from a combo box choice.

When i choose the customer number, i want the text boxes to fill with the details of that customer. Here is what i have so far.

Please Login or Register  to view this content.

When running this code i get a named arguments not found error and the search format section in red is highlighted.

Please help me get rid of this error for good.

Thanks

Adam

I have an older Mac version of Excel (Excel X), and Find does not include the SearchFormat argument. And, since you're getting an error, it looks like 2011 still does not include it. So, since it looks like you don't need the search to including formatting, you can simply remove it from the code...

Please Login or Register  to view this content.

Thanks alot Roy, That really helped.

Thanks to all that commented