Open the workbook, read the value, close it. You do not have to show it, but
you have to open it to read it.

"Jon Atkins" wrote in message
...
Hi

I have a Userform set up on a workbook called ISSUE.xls the closed
workbook is called REGISTER.xls

How can I get the value of the last cell in column A from a closed
workbook and then place that value into a Textbox on the Userform?

Thanks.