Many thanks - that works a treat.

On a related note do you know of a similar method to scroll through
labels on a form to populate them.

For example if I have now loaded a four part form is there a method to
do:

For i = 1 to NumberOfComponents
FormName.lblPart & i.Value = variable name
Next i

Again any help is greatly appreciated.

Adam.


--
Adamaths
------------------------------------------------------------------------
Adamaths's Profile: http://www.excelforum.com/member.php...o&userid=31580
View this thread: http://www.excelforum.com/showthread...hreadid=512724