User forms?
 

Is it possible to copy data from a range of cells and their formating and
display it in a form? Is there a way to just display cell values if not a
range or if not thier formating?
Thanks for the help!

User forms?
 

It's possible. But what are you trying to copy it to on the userform?
A lable, textbox, checkbox? If you can provide more info, I can hel
you with what you are wanting to accomplish.

John Wrote:
Is it possible to copy data from a range of cells and their formatin
and
display it in a form? Is there a way to just display cell values i
not a
range or if not thier formating?
Thanks for the help

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=53009

User forms?
 

Thanks for the quick reply! I don't have a real preference... I just want to
pop up a form that displays info from another worksheet and be able to close
it when done viewing... I don't need to enter anything into the form and
like I said in the first post... if the formating could be matched that would
be great! Does that help?

"dok112" wrote:


It's possible. But what are you trying to copy it to on the userform?
A lable, textbox, checkbox? If you can provide more info, I can help
you with what you are wanting to accomplish.

John Wrote:
Is it possible to copy data from a range of cells and their formating
and
display it in a form? Is there a way to just display cell values if
not a
range or if not thier formating?
Thanks for the help!


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=530097

User forms?
 

It is possible to put a Microsoft Office Spreadsheet on your userform. It is
available under the "Additional Controls" (at least, if you have a full
office install it should be). It is a limited feature version of Excel but
you can copy and paste into it, preserving the formatting.
--
- K Dales


"John" wrote:

Thanks for the quick reply! I don't have a real preference... I just want to
pop up a form that displays info from another worksheet and be able to close
it when done viewing... I don't need to enter anything into the form and
like I said in the first post... if the formating could be matched that would
be great! Does that help?

"dok112" wrote:


It's possible. But what are you trying to copy it to on the userform?
A lable, textbox, checkbox? If you can provide more info, I can help
you with what you are wanting to accomplish.

John Wrote:
Is it possible to copy data from a range of cells and their formating
and
display it in a form? Is there a way to just display cell values if
not a
range or if not thier formating?
Thanks for the help!


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=530097

User forms?
 

can this be linked to cells so that it always pulls current values off of my
sheet?

"K Dales" wrote:

It is possible to put a Microsoft Office Spreadsheet on your userform. It is
available under the "Additional Controls" (at least, if you have a full
office install it should be). It is a limited feature version of Excel but
you can copy and paste into it, preserving the formatting.
--
- K Dales


"John" wrote:

Thanks for the quick reply! I don't have a real preference... I just want to
pop up a form that displays info from another worksheet and be able to close
it when done viewing... I don't need to enter anything into the form and
like I said in the first post... if the formating could be matched that would
be great! Does that help?

"dok112" wrote:


It's possible. But what are you trying to copy it to on the userform?
A lable, textbox, checkbox? If you can provide more info, I can help
you with what you are wanting to accomplish.

John Wrote:
Is it possible to copy data from a range of cells and their formating
and
display it in a form? Is there a way to just display cell values if
not a
range or if not thier formating?
Thanks for the help!


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=530097

User forms?
 

I've never really worked with the built in userform on the sheet too
much. You can use a userform to reference certain data that is input
in a userform.

ex.

Sub CommandButton1_Click()
userform1.label1.caption =
Thisworkbook.sheets("Sheet1").range("B1").value
userform1.show
End Sub

This is just real basic. You can also code in the formatting that's in
the cell as well.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=530097

User forms?
 

ok have to play around with this and maybe get some more info later on!

"dok112" wrote:


I've never really worked with the built in userform on the sheet too
much. You can use a userform to reference certain data that is input
in a userform.

ex.

Sub CommandButton1_Click()
userform1.label1.caption =
Thisworkbook.sheets("Sheet1").range("B1").value
userform1.show
End Sub

This is just real basic. You can also code in the formatting that's in
the cell as well.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=530097

User forms?
 

If you need any help with it, let me know. I would need a little mor
specific info, like what type of formating, whether you want it as
change event or just a command button that you click, etc. but I ca
help you code it out

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=53009