excel VBA horizontal alignment problems when using NumberFormat codes

Question

Working on a personal project, When entering a fraction into Excel, I have found that if you don't have an equals sign in front of it then Excel may treat it as a date.

I have found that if the cell's format is in fractions then Excel uses it just fine.

So knowing this, I went into Excel's VBA and added this to my code:

ActiveCell.NumberFormat = "# ?/?"

a little later on I run this:

With ActiveCell
  .HorizontalAlignment = xlCenter 
  .VerticalAlignment = xlBottom 
End With`

however, now when I look at the Excel sheet the numbers are shoved up against the left side, even though the buttons say they are centered. I'm not sure what is going wrong here.

I don't have these problems if I do it manual, only when I have Excel do it.

To help with the problem I hosted the program I am creating online: http://www.4shared.com/file/169905671/bc73831e/Math%5FDrill%5Ffor%5FHighschool.html

Hopefully this will show what my problem is.

Answer 1

I have the same problem!!!