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


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558349

You must use a lable.

On userform activate / some other action:

label1.caption = Range("Sheet1!A1").text or .value


"T.c.Goosen1977"
<T.c.Goosen1977.2agtvn_1152091502.9314@excelforu m-nospam.com schreef in
bericht news:T.c.Goosen1977.2agtvn_1152091502.9314@excelfo rum-nospam.com...

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


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile:
http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558349

Thanks it works like a bom!

Theuns


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558349

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

Use a Label instead.
Label1.caption=WS.range("A1").value
Or use
TextBox1.Enabled=False
and/or
TextBox1.Locked=False

NickHK

"T.c.Goosen1977"
<T.c.Goosen1977.2agtvn_1152091502.9314@excelforu m-nospam.com wrote in
message news:T.c.Goosen1977.2agtvn_1152091502.9314@excelfo rum-nospam.com...

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


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile:
http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558349