Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help write Macro
Date Month
I have two columns as above Date and Month. I would like to use a macro to write the function =MthName(MONTH(A129)) in the month column in the same row when I populate the date field. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help write Macro
Hi
If it is only for display purposes, you don't need a macro In B2 enter =A1 then format the cell as follows FormatCellsNumberCustom mmmm Regards Roger Govier nc wrote: Date Month I have two columns as above Date and Month. I would like to use a macro to write the function =MthName(MONTH(A129)) in the month column in the same row when I populate the date field. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help write Macro
How about an alternative:
=text(a129,"mmmm") or =if(a129="","",text(a129,"mmmm")) nc wrote: Date Month I have two columns as above Date and Month. I would like to use a macro to write the function =MthName(MONTH(A129)) in the month column in the same row when I populate the date field. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help write Macro
Dave
Thanks for your suggestion, but I only wanted the cell populated if there was a date in the corresponding cell. "Dave Peterson" wrote: How about an alternative: =text(a129,"mmmm") or =if(a129="","",text(a129,"mmmm")) nc wrote: Date Month I have two columns as above Date and Month. I would like to use a macro to write the function =MthName(MONTH(A129)) in the month column in the same row when I populate the date field. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help write Macro
Roger
Thanks for your reply. "Roger Govier" wrote: Hi If it is only for display purposes, you don't need a macro In B2 enter =A1 then format the cell as follows FormatCellsNumberCustom mmmm Regards Roger Govier nc wrote: Date Month I have two columns as above Date and Month. I would like to use a macro to write the function =MthName(MONTH(A129)) in the month column in the same row when I populate the date field. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help write Macro
The second suggestion doesn't limit it to just dates, but it might be sufficient
if you only type dates in A129. nc wrote: Dave Thanks for your suggestion, but I only wanted the cell populated if there was a date in the corresponding cell. "Dave Peterson" wrote: How about an alternative: =text(a129,"mmmm") or =if(a129="","",text(a129,"mmmm")) nc wrote: Date Month I have two columns as above Date and Month. I would like to use a macro to write the function =MthName(MONTH(A129)) in the month column in the same row when I populate the date field. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Can I record or write a macro to send a worksheet via Outlook? | Excel Discussion (Misc queries) | |||
How to write a macro?? | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
how to write macro after autofilter is applied | Excel Worksheet Functions |