Thread: User Form Info
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
mudraker
 
Posts: n/a
Default User Form Info


Peter

yes a macro can read the value af cell h96 and have that displayed on
a form in a way that it can not be modified by the user

here is one way

Private Sub UserForm_Initialize()
Me.Label1.Caption = Range("h96")
End Sub


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=532475