Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem in Msgbox()
Hi All,
I am facing a problem in Msgbox() function. I dont know if the problem is caused by a limitation of msgbox or of Excel itself but I cant figure it out. Following is the exact (single) line of code I am using. s = MsgBox("Trading Interest (Client) : " & financing_total & vbCrLf & vbCrLf & corp_action & vbCrLf & vbCrLf & "CFD Dividend Received : " & cfd_interest & vbCrLf & vbCrLf & "Equity Interest Received : " & equity_interest & vbCrLf & vbCrLf & "Tax Amount : " & tax & vbCrLf & " Purchase / Sale <<<<<<<<<<<<<<" & vbCrLf & vbCrLf & " Equity ECU Equity S. Krona Equity CHF" & vbCrLf & " (L:16, L:17) (O:16, O: 17) (Q:16, Q:17)" & vbCrLf & vbCrLf & "Purchase : " & equity_eur_purchase_total & " " & equity_sek_purchase_total & " " & equity_chf_purchase_total & vbCrLf & vbCrLf & "Sales : " & equity_eur_sale_total & " " & equity_sek_sale_total & " " & equity_chf_sale_total & vbCrLf & " Transfer to Future / Forex <<<<<<<<<" & vbCrLf & "MS Equity ECU : " & equity_transfer_to_future_forex_AC_EUR & " MS SWAP GBP1 : " & Swap_transfer_to_future_forex_AC_GBP, vbOKOnly, "Please Note Down financial Figur for Today") I just want to add more spaces (and text) in between the message but excel is not allowing me to add anything more in this line. Is there a way to overcome this situation? Please Help. With Regards Ashish Sharma |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem in Msgbox()
Why don't you build a simple userform and setup the information in a nice
digestible manner rather than trying to cram it all into a MsgBox. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ashish128" wrote in message ps.com... Hi All, I am facing a problem in Msgbox() function. I dont know if the problem is caused by a limitation of msgbox or of Excel itself but I cant figure it out. Following is the exact (single) line of code I am using. s = MsgBox("Trading Interest (Client) : " & financing_total & vbCrLf & vbCrLf & corp_action & vbCrLf & vbCrLf & "CFD Dividend Received : " & cfd_interest & vbCrLf & vbCrLf & "Equity Interest Received : " & equity_interest & vbCrLf & vbCrLf & "Tax Amount : " & tax & vbCrLf & " Purchase / Sale <<<<<<<<<<<<<<" & vbCrLf & vbCrLf & " Equity ECU Equity S. Krona Equity CHF" & vbCrLf & " (L:16, L:17) (O:16, O: 17) (Q:16, Q:17)" & vbCrLf & vbCrLf & "Purchase : " & equity_eur_purchase_total & " " & equity_sek_purchase_total & " " & equity_chf_purchase_total & vbCrLf & vbCrLf & "Sales : " & equity_eur_sale_total & " " & equity_sek_sale_total & " " & equity_chf_sale_total & vbCrLf & " Transfer to Future / Forex <<<<<<<<<" & vbCrLf & "MS Equity ECU : " & equity_transfer_to_future_forex_AC_EUR & " MS SWAP GBP1 : " & Swap_transfer_to_future_forex_AC_GBP, vbOKOnly, "Please Note Down financial Figur for Today") I just want to add more spaces (and text) in between the message but excel is not allowing me to add anything more in this line. Is there a way to overcome this situation? Please Help. With Regards Ashish Sharma |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem in Msgbox()
You could declare a string variable and then build your message incrementally:
Dim strMsg as string strMsg = "Trading Interest (Client) : " & financing_total & vbCrLf strMsg = strMsg & vbCrLf & corp_action & vbCrLf & vbCrLf & strMsg = strMsg & "CFD Dividend Received : " and continue building the message until complete Then your msgbox statement would be s = MsgBox(strMsg, vbOKOnly, "Please Note Down financial Figur for Today") Kevin Backmann "ashish128" wrote: Hi All, I am facing a problem in Msgbox() function. I dont know if the problem is caused by a limitation of msgbox or of Excel itself but I cant figure it out. Following is the exact (single) line of code I am using. s = MsgBox("Trading Interest (Client) : " & financing_total & vbCrLf & vbCrLf & corp_action & vbCrLf & vbCrLf & "CFD Dividend Received : " & cfd_interest & vbCrLf & vbCrLf & "Equity Interest Received : " & equity_interest & vbCrLf & vbCrLf & "Tax Amount : " & tax & vbCrLf & " Purchase / Sale <<<<<<<<<<<<<<" & vbCrLf & vbCrLf & " Equity ECU Equity S. Krona Equity CHF" & vbCrLf & " (L:16, L:17) (O:16, O: 17) (Q:16, Q:17)" & vbCrLf & vbCrLf & "Purchase : " & equity_eur_purchase_total & " " & equity_sek_purchase_total & " " & equity_chf_purchase_total & vbCrLf & vbCrLf & "Sales : " & equity_eur_sale_total & " " & equity_sek_sale_total & " " & equity_chf_sale_total & vbCrLf & " Transfer to Future / Forex <<<<<<<<<" & vbCrLf & "MS Equity ECU : " & equity_transfer_to_future_forex_AC_EUR & " MS SWAP GBP1 : " & Swap_transfer_to_future_forex_AC_GBP, vbOKOnly, "Please Note Down financial Figur for Today") I just want to add more spaces (and text) in between the message but excel is not allowing me to add anything more in this line. Is there a way to overcome this situation? Please Help. With Regards Ashish Sharma |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem in Msgbox()
On Aug 30, 2:36 pm, "Bob Phillips" wrote:
Why don't you build a simple userform and setup the information in a nice digestible manner rather than trying to cram it all into a MsgBox. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ashish128" wrote in message ps.com... Hi All, I am facing a problem in Msgbox() function. I dont know if the problem is caused by a limitation of msgbox or of Excel itself but I cant figure it out. Following is the exact (single) line of code I am using. s = MsgBox("Trading Interest (Client) : " & financing_total & vbCrLf & vbCrLf & corp_action & vbCrLf & vbCrLf & "CFD Dividend Received : " & cfd_interest & vbCrLf & vbCrLf & "Equity Interest Received : " & equity_interest & vbCrLf & vbCrLf & "Tax Amount : " & tax & vbCrLf & " Purchase / Sale <<<<<<<<<<<<<<" & vbCrLf & vbCrLf & " Equity ECU Equity S. Krona Equity CHF" & vbCrLf & " (L:16, L:17) (O:16, O: 17) (Q:16, Q:17)" & vbCrLf & vbCrLf & "Purchase : " & equity_eur_purchase_total & " " & equity_sek_purchase_total & " " & equity_chf_purchase_total & vbCrLf & vbCrLf & "Sales : " & equity_eur_sale_total & " " & equity_sek_sale_total & " " & equity_chf_sale_total & vbCrLf & " Transfer to Future / Forex <<<<<<<<<" & vbCrLf & "MS Equity ECU : " & equity_transfer_to_future_forex_AC_EUR & " MS SWAP GBP1 : " & Swap_transfer_to_future_forex_AC_GBP, vbOKOnly, "Please Note Down financial Figur for Today") I just want to add more spaces (and text) in between the message but excel is not allowing me to add anything more in this line. Is there a way to overcome this situation? Please Help. With Regards Ashish Sharma- Hide quoted text - - Show quoted text - Thanks Bob but I dont know what a userform is and how to make it. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem in Msgbox()
On Aug 30, 5:56 pm, Kevin B wrote:
You could declare a string variable and then build your message incrementally: Dim strMsg as string strMsg = "Trading Interest (Client) : " & financing_total & vbCrLf strMsg = strMsg & vbCrLf & corp_action & vbCrLf & vbCrLf & strMsg = strMsg & "CFD Dividend Received : " and continue building the message until complete Then your msgbox statement would be s = MsgBox(strMsg, vbOKOnly, "Please Note Down financial Figur for Today") Kevin Backmann "ashish128" wrote: Hi All, I am facing a problem in Msgbox() function. I dont know if the problem is caused by a limitation of msgbox or of Excel itself but I cant figure it out. Following is the exact (single) line of code I am using. s = MsgBox("Trading Interest (Client) : " & financing_total & vbCrLf & vbCrLf & corp_action & vbCrLf & vbCrLf & "CFD Dividend Received : " & cfd_interest & vbCrLf & vbCrLf & "Equity Interest Received : " & equity_interest & vbCrLf & vbCrLf & "Tax Amount : " & tax & vbCrLf & " Purchase / Sale <<<<<<<<<<<<<<" & vbCrLf & vbCrLf & " Equity ECU Equity S. Krona Equity CHF" & vbCrLf & " (L:16, L:17) (O:16, O: 17) (Q:16, Q:17)" & vbCrLf & vbCrLf & "Purchase : " & equity_eur_purchase_total & " " & equity_sek_purchase_total & " " & equity_chf_purchase_total & vbCrLf & vbCrLf & "Sales : " & equity_eur_sale_total & " " & equity_sek_sale_total & " " & equity_chf_sale_total & vbCrLf & " Transfer to Future / Forex <<<<<<<<<" & vbCrLf & "MS Equity ECU : " & equity_transfer_to_future_forex_AC_EUR & " MS SWAP GBP1 : " & Swap_transfer_to_future_forex_AC_GBP, vbOKOnly, "Please Note Down financial Figur for Today") I just want to add more spaces (and text) in between the message but excel is not allowing me to add anything more in this line. Is there a way to overcome this situation? Please Help. With Regards Ashish Sharma- Hide quoted text - - Show quoted text - Thanks Kevin, It worked like a charm. Many thanks to you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MsgBox | Excel Discussion (Misc queries) | |||
Msgbox | Excel Worksheet Functions | |||
Problem with array and msgbox | Excel Worksheet Functions | |||
Problem with array and msgbox | Excel Worksheet Functions | |||
Problem with array and msgbox | Excel Worksheet Functions |