I have a Form "A" there is a combobox on Form "A" to pick a customer from a list (Named Range). IF the customer is not on the list yet, I use another form, Form "B" to add to the Customer list. I then want to return to Form"A" and use the list with the new customer added to it.
I get both forms open and can add to the customer list, and all that, but when I use the named range as the row source for the combobox on Form "A". I get an "Method pout of range" error, and excel shuts down. Any ideas?
I get both forms open and can add to the customer list, and all that, but when I use the named range as the row source for the combobox on Form "A". I get an "Method pout of range" error, and excel shuts down. Any ideas?