solved

I am working on a Part Number book for the company that I work for. Basically its the breakdown for every type of equipment that we have. Each tab is a different piece or category of equipment, how to create the part number and how to read the part number. While following the steps to create...

Hello Everyone, I've created this button on a userform on-screen keyboard to cycle through all the textboxes on another userform. After the 21st textbox (21st by TabIndex) it returns to the first textbox and starts over. What's happening though is that after making it through 22 boxes it...

Sorry wasn't sure how to label this one. I have multiple textboxes on UserFormMain. Whenever a textbox is selected I'm wanting to make x = the path of the selected textbox on UserFormMain. For instance when this textbox is selected I'm wanting x = UserFormMain.TextBox1.Value and then show...

Thought this one would be easy, not getting any results or errors and not sure where to go from here. Most of what I can find on concatenating doesn't concern cell addresses. Trying to get all the populated cell addresses in range D3:GE50 together in a single cell (Sheet2.Range("A2"), after...

Hello everyone, I'm adding sequential lettering to every cell greater than 0 in the loop, that part works fine. What I can't figure out how to do is reset the lettering to "a" every time "bcell" hits column D. The highlighted text is me fumbling around at a solution, without the blue text the...

Hello, I have this bit of code below pretty much working with one exception. The code takes the selections from 4 separate multi select listboxes on UserFormSplitBid and places the values from each listbox in cells A2:D2 respectively on sheet8. As long as all listboxes have a selection made...

Greetings, I have manage to create the appropriate merging of my data to a single worksheet, and created Column A to validate the row and tell me if "True", then I need the row or "False", I can delete the row. Is there simple VBA code that can check a given worksheet and delete any row where...

I am writing a tool to create quotations at work. Not really in the scope of my job, but it needs to get done. I am having trouble with the below loop. I cannot for the life of me (after much trial and error and the failure of my Google Fu) figure out how to get the below to work. I keep...

Hello, Please see my code below: I'm trying to divide my traded volume by the market volume. I think the below code should do this, but some of the answers it produces are incorrect. Has anyone got any idea why this might be please? Thanks Jo ' Define Calculated Fields...

Hi I have keywords in a named Range called Table. I'm trying to see if a an excel report has any of these keywords in Column O and if so, return that keyword. The formula I've tried is =IFERROR(INDEX(Table,MATCH(TRUE,ISNUMBER(SEARCH(Table,"*"&O2&"*")),0)),"Not Found") All it returns is Not...

I have a column of daily rainfall data in, say column A. What I want to do is apply a loss to that data, so that each time a new rainfall event occurs (i.e. there was no rain the day before), it will take off say 20mm. HOWEVER, the rain on that day might be less than 20mm, and also the day...

Evening All, I have a large pricing spreadsheet with a 'results' sheet that schedules each item and their respective quantities / unit rate / total cost. The number of items is a dynamic range and the results sheet is currently created using a userform. What I'm trying to do is allow the user...

Hi, I am trying to improve my code for find and remove the empty row below the cells that contain "12-2014". Unfortunately, I could not figure this out. Your help will be deeply appreciated. Cells.Find(What:="12-2014", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart...

Hi Everyone, I have this loop I'm building and there's one part (highlighted blue) where it takes all cells with the color index of 46 and places their values in this cell Sheets(1).Cells(2, 81).Value. At the moment each one overwrites the previous. What I'm looking for is for the text to...

I'm trying to have a formula reference certain cells and sheets. Because the sheet and which column it reads from can change, I need to be able to have the user select the range from an input box and then have those ranges print in the cell formula, but I can't figure it out! Here is the...

Hello Again, In the highlighted text area I'm wanting the value of the first row on sheet1 from the active icell column. Can't figure out how to lift that value from the sheet. It's text in the cell as well that's being transfered, not a number. Sub TestCode()Dim iCell As Range, ws As...

Hi Guys, New at loops here, this is copying the data I need to a new sheet but it's all landing in the same two cells and overwriting the previous data instead of skipping to the next row down each time before pasting the next. Sub TestSub()Dim iCell As Range Lastrow =...

Hi Again, I've got a userform with 8 togglebuttons and a confirm commandbutton. When I press the confirm button I want it to paste a value in certain cells depending on which toggles were true and do nothing for the ones that are false. I'll just say ToggleButtons1-8 for now left to right...

Hi, I am trying to code the following formula, a combination of IFERROR, INDEX, and Match, in VBA. Unfortunately, the code below does not work. Your help will be fully appreciated. Dim i As Long For i = 2 To X Range("D" & i & ":BJ" & i & "").Select...

Hello All, Working on my estimate spreadsheet. The goal is to be able to walk into a customers house with my tablet and be able to pick the items off of a userform. For ease of use I've increased the font size from default and am wanting to eliminate the need to use scroll bars as much as...