Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA vs Time fields
Hey all, sort of teaching myself excel and vba to simplify some work, done a
lot of reading but I'm not getting the hang of one aspect. I need to have two time fields in my form, in which the user will enter a value of minutes and seconds, in the format of mm:ss, have it stored in a cell pointed to by other factors (arbitrarily use A1 and B1 for example purposes) with the ability to be mathematically manipulated by fields filled with integer values (A2, B2, C1) with results stored in field (D1 such that D1 = ((A1 * A2) + (B1 * B2))/C1 I think the core problem I'm having is getting the Data entered into the TextBox to translate as not a string, and am a little lost, I believe the math will work fine whats it's actually a time in excel's view, so it's really the VBA code side of things I need. Thanks for any advice. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
How can I sort 4 fields at a time | New Users to Excel | |||
Adding Date/Time fields | New Users to Excel | |||
COUNTIF use with fields of time | Excel Worksheet Functions |