Search results for query: *

I'm using Excel 2010. Interested in obtaining which columns in a row are populated with information and then storing it to a variable. How would I go about getting this? TIA, Tim

Thanks for the information Skip - interesting.

You are correct sir. It is suppose to be 25 minutes and 12 seconds. When I attempted to format, the format would not take. Thanks.

Thanks for the quick reply Skip. I have formatted the cell to MM:SS@ hoping for time display 10:12 example. Unfortunately, when I enter 25:12 as an example, Excel will convert to 12:00. Thanks.

Yes, it does display a decimal. So, when I need to calculate, how would I go about formatting it back into time (mm:ss). Thanks.

Hi All, I am looking to format a column for time i.e. minutes:seconds. I've tried custom formatting etc. no luck. Any help would be appreciated. Thanks.

Your suggestions were great. Thanks MajP and theAceMan1 for your help.

Hi All, Attempting to change a control's backcolor via a variable. Calling sub changeBackColors and setting strControlName to current control. Problem is when I attempt to execute Me!strControlName.BackColor = vbYellow, I get a syntax error. I know my syntax at Me!strControlName is wrong...