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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top