discard

  1. A

    I want Excel 365 to lock the file when in use

    This is causing huge problems in my office and I've tried to find a solution to no avail - so here I am... We are using office 365 with auto-save off for our check register in Excel, when I am in the file and someone else opens it Excel wants me to save a copy or discard changes. I remember...
  2. kelly mort

    Discard unauthorized characters with keypress event

    I have used this code to discard all characters except numbers. Now I want to allow the input of points too but I can't make it happen. Can someone fix it for me? Private Sub TextBox1_KeyPress (ByVal KeyAscii As MSForms.ReturnInteger) KeyAscii = KeyAscii * -CLng(Chr(KeyAscii) Like...
  3. W

    VLOOKUP to find repeats?

    Below is a small sample of data that I am working with. Test parts are identified as 01-24 in column A. Location in Column B is location of test part. The tech in Column C will be S1, S2 and S3. Column D is the max value (resistance) for each Tech. Once a part is used in one test, it cannot be...

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