Userform1.show
Userform2.show
Userform3.show

you show the forms.

Use a defined name for the rowsource

When you add a row, redefine the named range and reset the rowsource.

Worksheets("Sheet1").Range("A1").currentRegion.Nam e = "Table1"

You don't have to delete the name if it already exists, this redefines it.

Dim res as Variant
res = application.Match(Textbox1.Text,Range("Sheet1!A:A" ),0)
if not iserror(res) then
msgbox TextBox1.Text & " already exists"
Textbox1.Text = ""
exit sub
End if

Some additional sources of information:



http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data


http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


http://j-walk.com/ss/excel/tips/tip84.htm


See this tutorial here
http://www.dicks-blog.com/excel/2004...g_userfor.html


http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel




XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514


XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749


Here are some other sources of information:


http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel
http://support.microsoft.com/default...b;en-us;829070


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms


Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en.../Introductiont...
Part II
http://msdn.microsoft.com/library/en.../Introductiont...



--
Regards,
Tom Ogilvy


"Amber_D_Laws"
wrote in message
news:Amber_D_Laws.22bain_1138396207.6586@excelforu m-nospam.com...

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