9.value

  1. J

    Userform dependent combo boxes

    Have the following code to try that attempts to allow you to use the drop down in a userform which is dependent on the other. It is setup with an advanced filter in the spreadsheet. The problem I am encountering is that nothing shows in the dropdown box (combo box1), any ideas? Thanks. Private...
  2. M

    Conflicting codes?

    I have code that puts data into columns depending on weather or not the check box is checked. I also have code that checks the value of the cell and re-checks the box if >0 I Can't seem to get both codes to work, whichever on I have first works but the other doesn't. If I switch the order then...
  3. H

    VBA to sum a range in a different worksheet

    Hi, I can usually make my VBA code work but I just can't seem to get the sum function to work properly. I have a sheet for every person in my small business (8 people), each sheet is named after the employee. Their time gets entered into their sheets every day (so I have the date, time in...
  4. V

    Check Box

    I have multi Check box's on userform, then below code is adding the record in 1 cell only, its not working as required. The code to search the lastrow in column J and once the user select the checkbox1 the label caption should be the cell(lastrow), if the user selects checkbox2 then label...
  5. sharky12345

    Error 13 - Type Mismatch

    I'm getting an error 13 Type Mismatch on the following line but I have no idea why, if anyone can assist? If InStr(cell.Value, "P.T.") Or InStr(cell.Value, "Temp Gt") Or cell.Offset(0, 9).Value = "AP" Or cell.Offset(0, 9).Value = "A/Gt" <> 0 Then
  6. W

    Help with VBA Code - Delete Rows based on Criteria

    Hello Everyone I have the below code where I am copying rows from the data tab that contain Day1 or Day2 or Day3 in column 9 and pasting these rows into the "Data2" tab. I then want to delete all the rows I have pasted to the new tab from the original data tab but am not sure how to do so. Some...
  7. Y

    Help with VBA coding

    Hi there, Stuck with an issue for over a week and need someone to point me in the right direction. I recorded a macro to do a advanced filter and copy the data to another sheet. Works great with one drawback! I have over 3000 rows and created Do While Loop to get the values into 2 different...
  8. J

    Making code dynamic

    Hi, I have this code which seems not proper when there's any change in input file. The code I made is Static which I want to convert into dynamic. The problem is I don't know the way. Here's the code I've made which I want as dynamic as possible: Private Sub OutputBttn_Click() Dim fName As...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top