On Sat, 18 Sep 2004 07:05:45 -0500, Dave Peterson
wrote:

I'd use a cell in a worksheet (hidden??) or just out of the way:

=LOOKUP(2,1/('C:\My Documents\excel\[register.xls]Sheet1'!$A$1:$A$9999<""),
'C:\My Documents\excel\[register.xls]Sheet1'!$A$1:$A$9999)
(all one cell)

Then populate the textbox from that cell.

(change 9999 to a big number, but don't use the whole column)

That did the trick
I had hacked and slashed at some of Ron de Bruin's code, but your
method has tidied up a mess and reduced the file size.

Many thanks to both you and Bob kilmer for replying