Recent content by jrobin5881

You guy's are the best! Happy Holidays to you all. Thank you.

REPOST- Put the original message in wrong forum by mistake. 8( I'm looking to put a formula together in one cell versus many. I've tried using the "If" statement but its to messy. I have an example of the table below. What I want to do is in cell A3 have a formula that looks to the right (Col...

Disregard my last post... I did what you said and found the culprit!!! This is an excellent tip, thanks so much

Skip, Yes, I have some locations that take over an hour to get to(1:01, 1:40) etc. I read your link on time but was not sure what to do to correct. Should I parse out the hours to it's own column and just calc the minutes?

1.984583333

Skip, Nope, no hidden rows and not sure that would account for it anyway because I'm just changing the format of the sum cell. I Can't figure it out? making me nuts.

I found that when I change the summation cell from [h]:mm to h:mm I get the right answer 0:17 0:06 0:26 0:47 0:17 0:29 0:22 0:35 0:32 0:26 0:17 0:15 0:36 0:00 0:32 0:29 0:09 0:27 0:24 1:01 0:12 0:00 0:24 0:08 0:18 0:29 0:26 0:47 1:01 0:25 0:29 0:26 1:01 0:29 0:29 0:00 0:40 0:27 1:01 0:15 1:00...

I've developed a spreadsheet comparing travel times. I have the time from point A to point B listed in one column. I have time from a different point A, to the same point B listed in another column. The time is formatted as h:mm for each of the cells. At the bottom of each of the two columns I...

Good Afternoon, I posted this under the VBA site earlier this morning and no response so I thought perhaps it belongs under the Sharepoint section instead and I've reposted here. I built an Excel app using VBA and a series of Userforms that I migrated up to a Sharepoint site. The file runs...

Good Morning, I built an Excel app using VBA and a series of Userforms that I migrated up to a Sharepoint site. The file runs fine on my local machine but gives me an error message when run from Sharepoint. DETAILS: I hide the application in the background when the workbook is opened...

I have another Userform question. I have coding so that scroll bars appear and work fine on the right side of my form so that my users can scroll up and down by clicking and dragging the bar up and down. How can I make my form scoll as my users tab from one textbox to the next? Or if the user...

Thank you again skip

Okay, will do. I'll move them to another sheet. Thanks guy's

I'm missing something. I have a userform with a series of textboxes for my end users to input information. I then have the "Save As" dialog box to save the workbook open when the user has completed the form. My "expectation" is that the data entered into the text boxes will remain there when the...

Fumei, Thanks for the followup. Here's what was ocurring (which I didn't want): The Cells(4,4) is where the text from the first txtbox needed to go. So when i = 4 was inside the loop it kept changing i back to 4 with each iteration. For t = 5 To 14 i = 4 Sheet29.Cells(i, 4) =...