nrk

  1. I

    Cell must be 11 or 17 characters

    Hi & Good Morning, I have been working with a code for a while where the cell in question must have 17 characters otherwise the code would do its job. Example SHHFN13408U004767 I have recently had the need to now allow 11 characters. Example RG3-1009939 So the code needs to be working for 11...
  2. I

    Userform as opposed to Msgbox

    Hi, For many reasons the standard Msgbox is no use for me in this case so i have made a userform. My problem lies with editing the code to know accept / use the userform. The 2 text boxes on the userform as advised for you. txtQuantitySold would be the value from the countif formula column F...
  3. I

    Edit to current working code is needed please

    Morning all, Can you advise how i would go about the following request please. Each day i would enter data into my worksheet. The cells in question are always the same. The cell the data is entered into is A17 As i leave this cell in question i would like some code to look at the 10th character...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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