Search results for query: *

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) =...

Skip, Thanks BUNCHES!!! I learned a heap through this exercise and my coding is now much tighter. Through your guidance I see where I was going wrong. I have to set the value of the variable "i" before I dropped into the loop. I did some reading on the debug.print and definately see the value...

Yes I have my Project Explorer window open and it says Sheet29(Quarterly) I'll have to do more reading on the use of the immediate window for debuggin. txt2045 is the first textbox on the form. The second one is txt2046 is the second one and so on. So coming into the loop the value of the...

Hey Skip!, I'm trying to get better at my coding so instead of using the sheet name ("Quarterly") in this instance, I was using the the sheet number. I picked that up from some reading on did on the net that said it's better to use the number of the sheet rather then the name so that if the...

PHV Thanks but its not working? It's not crashing and I'm not getting an error message but the text from the textbox is not moving to the recap sheet (sheet29). See ammended code: Private Sub CommandButton6_Click() Dim t As Integer Dim i As Integer For t = 5 To 14...

Good Morning, I have a userform with multiple textboxes and a "Submit" command button below. I want the user to add values, text to the textboxes and have the data post to a master sheet when they're done. I know how to do this with one textbox at a time however I'm trying to streamline the...