Thankyou both, Works a treat.

Any reccomended reading for excel programming? I like the VBA system for
some reason.

Thanks again
Peter

"mudraker" wrote:

>
> 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
>
>