Thank you both for the solutions. I really appreciate it.

Frank


"Frank & Pam Hayes" wrote in message
news:oE51f.13366$Vt3.12370@trnddc01...
I have created an Excel Add-In that formerly displayed the add-in's version
and date in a message box based on values in one of the add-ins worksheets
using the following (where A1 contained the version number and A2 contained
the date last updated):

Sub DisplayVersion

Msgbox "Version "&Worksheets("Sheet1").Range("A1")& _
" updated on "&Worksheets("Sheet1").Range("A2")

End Sub

I am trying to move this function to a UserForm but can not figure out
how to get data from a worksheet into a string of text in a label within
the UserForm. Can someone point me to an example?

Thank you,

Frank Hayes