| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Forms | New Users to Excel | |||
| user forms | Excel Programming | |||
| User forms help | Excel Programming | |||
| User forms | Excel Programming | |||
| User Forms | Excel Programming | |||
Linear Mode
