expecting

This line of code is not giving me the rsults I expect. .uf1_month.Value = Format(usr_mnth, "mmm") usr_mnth = 4 Expecting the value of combobox uf1_month to be "Apr" but it's being displayed as "Jan" Corrections?

Hi Please have a look at this workbook. There are oddities in the sum in cell B12107. I was expecting that the sum would have values only in 2 decimal places. Likewise, in column B, I was expecting values in only the first 2 decimal places. Is this the expected behavior? I get the same...

HI Everyone, Need help with formula which can return the closest non blank value. Providing sample data table below. Column C shows the results i am expecting. Thanks <tbody> Column A Column B Column C Expected result 10 A A B A C A 20 D D E D F D G D 30 H H I H </tbody>

Hi I did write that custom formatting. Now if I type 100 then 100 will be green. If I type 0 then excel will put nothing in that cell. If I type Hello then excel keep the same text, same black color. So far so good, but when I type -100 excel will change it to Green -100 ?? why is that?? I was...

I am trying to write code to insert this formula into a cell but it is coming up with an error box saying that it is expecting an ending. Can anyone help? Cells(1, 8).Value = "Letter Grade" Cells(2, 8).Activate ActiveCell.Formula =...

I am trying to get the # of hours between two time values. I am using this line of code in my attempts to do so ... Me.uf8g_e_minsdev = format(TimeValue(Me.uf8g_apetime) - TimeValue(Me.uf8g_petime), "0.00") Me.uf8g_apetime = "9:00 PM", and Me.uf8g_petime = "8:30 PM" The result I get...