Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Msg.box -messages
Is it possible to format messages in msg boxes in vba ?,If yes how ? I would
like to change the font and background color of a message,in a macro. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Msg.box -messages
Hi
(AFAIK) No. However you can use a userform (insert/userform in VBE window) to make your own message box and then call this via code (userform1.show). Userforms can be formatted however you like. -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "TUNGANA KURMA RAJU" wrote: Is it possible to format messages in msg boxes in vba ?,If yes how ? I would like to change the font and background color of a message,in a macro. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Msg.box -messages
Is it possible to insert a user form/table in a cell to enter data in that
form/table,and cosolidated sum of that a form column value will update the cell value. .."JulieD" wrote: Hi (AFAIK) No. However you can use a userform (insert/userform in VBE window) to make your own message box and then call this via code (userform1.show). Userforms can be formatted however you like. -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "TUNGANA KURMA RAJU" wrote: Is it possible to format messages in msg boxes in vba ?,If yes how ? I would like to change the font and background color of a message,in a macro. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Msg.box -messages
Hi
Not sure if this question is the related to your first question or a completely different one. If you would like to explain in a bit more detail what you're trying to achieve we will probably be able to more effectively assist you. From my reading of this question you have a cell (let's say A1) and you want to be able to type a new value in A1 and have it added to the previous value in A1 rather than replace the previous value? Is this what you're after and if so, how does the message box / user form / table come into it? -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "TUNGANA KURMA RAJU" wrote: Is it possible to insert a user form/table in a cell to enter data in that form/table,and cosolidated sum of that a form column value will update the cell value. ."JulieD" wrote: Hi (AFAIK) No. However you can use a userform (insert/userform in VBE window) to make your own message box and then call this via code (userform1.show). Userforms can be formatted however you like. -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "TUNGANA KURMA RAJU" wrote: Is it possible to format messages in msg boxes in vba ?,If yes how ? I would like to change the font and background color of a message,in a macro. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Msg.box -messages
Thanks ,Julie. First this question is not related to first one.second part
you are right,whenever I click cell A1 I can type a new value that will add previous value in that cell.Third part ,why I need user form /table when I click that cell,let me explain my task. col A-------col B-------------col C------------Col D item -------Qty.Ordered----Qty.supplied----Balance to supply Milk---------15000 litrs------200 litrs-------14800 whenever I click C2,a form wiil populate where in I will enter today's date and qty supplied, current supplied qty will be added to Col c2 qty.col B qty is fixed for one year.Col D is calculation.Col c qty details will populate whenever I click that cell so that I can view last quantities also. This is my task "JulieD" wrote: Hi Not sure if this question is the related to your first question or a completely different one. If you would like to explain in a bit more detail what you're trying to achieve we will probably be able to more effectively assist you. From my reading of this question you have a cell (let's say A1) and you want to be able to type a new value in A1 and have it added to the previous value in A1 rather than replace the previous value? Is this what you're after and if so, how does the message box / user form / table come into it? -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "TUNGANA KURMA RAJU" wrote: Is it possible to insert a user form/table in a cell to enter data in that form/table,and cosolidated sum of that a form column value will update the cell value. ."JulieD" wrote: Hi (AFAIK) No. However you can use a userform (insert/userform in VBE window) to make your own message box and then call this via code (userform1.show). Userforms can be formatted however you like. -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "TUNGANA KURMA RAJU" wrote: Is it possible to format messages in msg boxes in vba ?,If yes how ? I would like to change the font and background color of a message,in a macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete blocked senders messages on receipt why junk mail them? | Excel Discussion (Misc queries) | |||
whiting out error messages | Excel Worksheet Functions | |||
Excel messages for Blackberry | Excel Discussion (Misc queries) | |||
all macros failing - different workbooks different error messages. | Excel Discussion (Misc queries) | |||
Weird error messages | Excel Discussion (Misc queries) |