Is there any way?
 

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

Is there any way?
 

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

Is there any way?
 

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

Is there any way?
 

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

Is there any way?
 

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