Hi Harry,

To get the information from a named range in your spreadsheet you can
use this:

frmName.txtName.value=worksheets("SheetName").Rang e("RangeName)

Then, once the user has edited the information you can use:

Worksheets("SheetName").Range("RangeName")=frmName .txtName.value

Cheers


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=520427