Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheet contents as result in a userform.
Hi all,
I'm trying to present a worksheet range as the result of calculations in a userform or separate window as a result of clicking a command button. i can't figure out how to show this worksheet range in my results userform. What control object can I use for this purpose? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheet contents as result in a userform.
Are you at a point ware you just need to insert the data from the use form, or do you still need to calculate the data and then insert it :confused -- AndrewA ----------------------------------------------------------------------- AndrewAK's Profile: http://www.excelforum.com/member.php...fo&userid=1554 View this thread: http://www.excelforum.com/showthread.php?threadid=27191 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheet contents as result in a userform.
Try converting the calculated range to a string variable and show it in a
text box "Ernie" wrote in message ... Hi all, I'm trying to present a worksheet range as the result of calculations in a userform or separate window as a result of clicking a command button. i can't figure out how to show this worksheet range in my results userform. What control object can I use for this purpose? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheet contents as result in a userform.
Hi Andrew,
Calculations are all done and I want to show the results in a userform. AndrewAK wrote: Are you at a point ware you just need to insert the data from the user form, or do you still need to calculate the data and then insert it? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheet contents as result in a userform.
This might not work as I have charts in my worksheet that go with each
table in it. N10 wrote: Try converting the calculated range to a string variable and show it in a text box "Ernie" wrote in message ... Hi all, I'm trying to present a worksheet range as the result of calculations in a userform or separate window as a result of clicking a command button. i can't figure out how to show this worksheet range in my results userform. What control object can I use for this purpose? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheet contents as result in a userform.
Hi Ernie
If all you want to do is show a representation of some range purely for informarion in a userform then what I suggested would work. What exactly are you trying to achieve ? Best N10 "Ernie" wrote in message ... This might not work as I have charts in my worksheet that go with each table in it. N10 wrote: Try converting the calculated range to a string variable and show it in a text box "Ernie" wrote in message ... Hi all, I'm trying to present a worksheet range as the result of calculations in a userform or separate window as a result of clicking a command button. i can't figure out how to show this worksheet range in my results userform. What control object can I use for this purpose? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel worksheet contents as result in a userform.
Hi N10,
My results worksheet contains tables and graphs. I need to show a representation similar to the print preview in a userform. I have never tried to convert a worksheet range to a string var, but am willing to give it a try. Regards, Ernie N10 wrote: Hi Ernie If all you want to do is show a representation of some range purely for informarion in a userform then what I suggested would work. What exactly are you trying to achieve ? Best N10 "Ernie" wrote in message ... This might not work as I have charts in my worksheet that go with each table in it. N10 wrote: Try converting the calculated range to a string variable and show it in a text box "Ernie" wrote in message ... Hi all, I'm trying to present a worksheet range as the result of calculations in a userform or separate window as a result of clicking a command button. i can't figure out how to show this worksheet range in my results userform. What control object can I use for this purpose? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform txt box contents | Excel Discussion (Misc queries) | |||
Edit cell contents via userform listbox | Excel Programming | |||
Format of textbox on userform and correct result | Excel Programming | |||
How to use combobox contents to get information for userform | Excel Programming | |||
UserForm Result Posting | Excel Programming |