rowselect

  1. S

    Mismatch Error VBA Excel

    Hello, I have the below code that have the purpose to update information in an already exiting database based on the TARA # in ComboBox1. This TARA # is the first column (A) in my workbook "TARADatabase). When I run the code, it gives me error 13 mismatch in the line i made bold in the code...
  2. J

    Solution not needed - just clarity on a piece of this code!

    Hi folks, I got the below code online somewhere a a few months back and its recently come in handy for something I'm doing (copying every other row and pasting it elsewhere). However, I'm new to VBA and do not understand 1 thing (which is a problem since I'll need to troubleshoot): why does...
  3. C

    VBA Loop and convert cell to values until cell is blank

    Hello, i would like help in creating VBA code that will convert the 1st cell in the selected column...lets say column "E" and then every 4th cell after that from formulas to values until the last row.."180000" or when the next cell is blank. I found this code that works for me but you have to...
  4. P

    Update Row when ID is found

    Hi I have the code below for the ID which is textbox18, what I want is if a person has an update they go into the userform and enter the number id then what they want updated in other textboxes and then click the update button. what this should do is find the ID in sheet1 and update the same...
  5. B

    Facing Runtime Error - 13, Type of Mismatch

    Dear Experts, This is duplicate thread originally posted in VBA express forum and link is http://www.vbaexpress.com/forum/showthread.php?63295-Facing-Run-time-error-13-quot-Type-Mismatch-quot-while-edit-and-update-user Kindly help me to resolve this issue. I have developed user form for...
  6. E

    My VBA code to edit entries in Excel only works on one column/field

    Hi guys, I have a listbox linked to an excel sheet and I have created a small "update" button that allows me to modify each entry. However, the code only runs on the first row of code and I do not understand why it does not update the following fields. It seems as if VBA stops looking at the...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top