Hey Jakey,

Thanks for the ideas! I will keep both you and Tom posted as thing
progress.

I considered MultiPage Controls, but there are several steps, and
want my users to go through them in a precise order. It is m
understanding that a multipage has tabs, and the users would be able t
shift from one to the other, and in that way they might miss a step. Or
am I wronge. Admitidly I don't know a whole lot about user forms, s
please if I am off base let me know where my thinking strayed.

See ya' around,
Amber:)


JakeyC Wrote:
A lot to answer, so a brief starting point for you:

1. It sounds like you might benefit from using a MultiPage control on
a single form - see VBA help for more info on how they work. If you
really do need separate forms, then perhaps use the Deactivate even
of
one Form to call .Show method of the next.

2. Use something like:

lastrow = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
ComboBox1.RowSource = "A1:A" & lastrow

to set the ComboBox1 range to be the last row with data in column A on
Sheet1. Change according to where your actual data is!

As for avoiding duplicates, it would be handy if you had a set format
for clients' names to check - just in case "James Thompson LTD." gets
entered as "J Thompson LTD." in the future.

Have a look at Application.Find to help with searching for text etc

--
Amber_D_Law
-----------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...fo&userid=3001
View this thread: http://www.excelforum.com/showthread.php?threadid=50587