Roedd <<T.c.Goosen1977 wedi ysgrifennu:

is there any way of displaying a value of a specific cell in a frame
when the userform is loaded without creating a Textbox and displaying
the value in the textbox...directly in the frame? (cause u can still
edit within the textbox)?

Thanks

Set the Locked property of the textbox to true. Then you can't edit the
content at run time.

Rob