Hello Again,

As some of you already know, I have been working on a quote module for
my company. After extensive gnashing of teeth, and pulling of hair as I
fought with several coding problems, I have completely ditched the first
try, and I am now on round two.

I realized most of my problems were stemming from my trying to prevent
my users from being able to unintentionally mess things up, while
keeping the whole thing friendly to those that are not friendly with
computers.
Through all my research, it finally dawned on me that I need to be
using a series of user forms.

User forms seem easy enough, and so far making it look like I want
isn't a problem at all. Figuring out how to get it to put the
information into Excel the way I want has been. This leads me to the
first two questions in what is likely to be a long series of questions
in the future.

1. What code do I use to sequentially have the user go through the
user forms in the order I want them to.

And

2. I have a list of client names with their corresponding contact
information in a combo box, so my users are picking the client they
want to quote from the drop down list. Because we frequently quote new
clients, I wanted a way to give them an option to add a new client. No
problem. I found the code to add them to the list, and it works!
Hurray
The question is, how do I expand the row source to reflect the new
addition/s, and how do I keep the users from adding duplicate clients.

Any advice will be helpful.

Thanks in advance to everyone who reads or posts to this tread.
Amber :)


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=505875