I am new to macro writing and need some help. I need to write a simple VB macro for MS Excel that will format two columns:
One column I need to add a 0 before the number. So that when the user enters 7 in the Excel column the macro will format that column by adding a 0 in front of it. The result will be a 07 in the field.
The other column I need to have the macro convert a month and day date to this fomat MM/DD.
Some basic macro code I have is:
ActiveCell.FormulaR1C1 = "X"
but I need to format the cells. how do I do this?