View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank & Pam Hayes[_2_] Frank & Pam Hayes[_2_] is offline
external usenet poster
 
Posts: 34
Default Displaying Cell Value in UserForm Label

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