masking

  1. C

    SumProduct on a variable length using a mask

    I have been using this formula {which is working fine} SUMPRODUCT( N( MOD( COLUMN( $I37:AJ37)) -6, 7)= 0), $I37:AJ37) +F37 where the first part creates a mask for every 7 column, Middle part is numbers, text and blanks which only every 7th is needed, and the last part is a offset value. I...
  2. V

    Excel VBA form: force users to enter a letter follow by a number?

    Hi, let's say that I have a input box on my form called "searchbox". I want the users to have to enter a 6 digits postal code, ex. "L9A2C7". I want them to enter a letter follow by a number until they reach 6 digits - no space allow. So if they try to type mm for example, they would only have...
  3. B

    Masking Numbers

    I have a set of numbers in column B <tbody> <tbody> 07.01.01.01.01 </tbody> <tbody> 07.01.01.03.01.01 </tbody> <tbody> 07.01.01.04.01 </tbody> <tbody> 07.02.01 </tbody> <tbody> 07.02.04.04 </tbody> </tbody> I would like a fill formula to fill column A and reduce the...
  4. B

    Masking numbers

    Hi All, I have the following problem... I have many numbers in the following format associated with several costs: A B C 06.01.01.01.01 £8000 £40000 06.01.01.01.02 £2000 £50000 06.01.01.02.01 £9000 £60000...
  5. J

    masking password when asking for it with *********

    my code is below, I just need to understand how to mask the password entered as *******? just to stop other users seeing it next to me. thanks in advance Sub Openall() Dim password As Variant password = Application.InputBox("Enter Password", "Password Protected") Select Case password...

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
Back
Top