User forms?

[John]

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]

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.

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!

[John]

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

[K Dales]

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

[John]

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

[dok112]

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.

[John]

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

[dok112]

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