THE BEST

C:\Users\somet>help For more information on a specific command, type HELP command-name ASSOC          Displays or modifies file extension associations. ATTRIB         Displays or changes file attributes. BREAK          Sets or clears extended CTRL+C checking. BCDEDIT        Sets properties in boot database to control boot loading. CACLS          Displays or modifies access control lists (ACLs) of files. CALL           Calls one batch program from another. CD             Displays the name of or changes the current directory. CHCP           Displays or sets the active code page number. CHDIR          Displays the name of or changes the current directory. CHKDSK         Checks a disk and displays a status report. CHKNTFS ...

Excel VBA_ Employees Form with Auto id, combobox, textbox, phone number and email validation

 Shorcut of Microsoft Windows ======================= use of key windows with the following key shift = Screenshot F1 = edge browser F3 = Find F5 = Time and Date pageup/down = go through file up/down shift arrow keys to change directions Ctrl Shift Esc = Task manager q = search w = online information from left windows e = file explorer r = run u = accessibility i = system p = project 1 = this pc / my computer 2 = microsoft edge browser 3 = microsoft store 4 = microsoft office  5 = microsoft excel 6 = microsoft powerpoint 7 = microsoft publisher 8 = microsoft access 9 = snipping tool 0 = google chrome = = magnifier a = internet access s = Search d = minimize/maximize windows f = feedback hub g = Xbox h= speark typing k l = logoff ; = imoji z = View x = windows manager? c = Account v = Clipboard  b = Show Hidden icon n = Calendar m = minimize . = emoji

 Date systems in Excel Excel supports two date systems, the 1900 date system and the 1904 date system. Each date system uses a unique starting date from which all other workbook dates are calculated. All versions of Excel for Windows calculate dates based on the 1900 date system. Excel 2008 for Mac and earlier Excel for Mac versions calculate dates based on the 1904 date system. Excel 2016 for Mac and Excel for Mac 2011 use the 1900 date system, which guarantees date compatibility with Excel for Windows. When you copy dates from a workbook created in an earlier version to a workbook created in Excel 2016 or 2011 for Mac, they will be converted automatically unless the option to "Automatically convert date system" is disabled in  Preferences  >  Edit  >  Date Options . If this option is disabled, you will receive a message asking whether the dates should be converted when pasted. You have two options. You can convert the dates to use the 1900 date syst...

What Is CHKDSK CHKDSK is a command that can be run in Command Prompt to verify the logical integrity of the file system. The full name of CHKDSK is actually checkdisk; as the name suggests, it is designed to check disk for errors and then fix it. CHKDSK works on the basis of certain partition file system to create and display the disk status. If CHKDSK is typed without any parameters, the disk status in the current drive will be displayed to people. ===============  C:\Users\somet>chkdsk /? Checks a disk and displays a status report. CHKDSK [volume[[path]filename]]] [/F] [/V] [/R] [/X] [/I] [/C] [/L[:size]] [/B] [/scan] [/spotfix]   volume              Specifies the drive letter (followed by a colon),                       mount point, or volume name.   filename            FAT/FAT32 only: Specifies the files to check for         ...

 C:\Users\somet>ping /? Usage: ping [-t] [-a] [-n count] [-l size] [-f] [-i TTL] [-v TOS]             [-r count] [-s count] [[-j host-list] | [-k host-list]]             [-w timeout] [-R] [-S srcaddr] [-c compartment] [-p]             [-4] [-6] target_name Options:     -t             Ping the specified host until stopped.                    To see statistics and continue - type Control-Break;                    To stop - type Control-C.     -a             Resolve addresses to hostnames.     -n count       Number of echo requests to send.     -l size        Send buffer size.     -f             Set Don'...

  How to Open Windows Tools Using the Classic Control Panel While Microsoft is slowly moving away from it, you can still  open the Control Panel in Windows 11 . It still exists and houses many advanced options, such as Windows Tools. Here’s how to do it: Press the  Win  key and type  control . Next, click on the  Control Panel  option from the search result. When the Control Panel opens, click the  View by  drop-down in the top left corner and select  Small Icons . This will list all the Control Panels items. Next, locate and click on the  Windows Tools  option to access your admin tools.

 How to Open Windows Tools Using the Run Dialog You can use the classic Run dialog to open Windows Tools. If you memorize the command, this method can be one of the fastest ways to access Windows Tools. To open Windows Tools using the Run dialog: Press  Win + R  to open the  Run  box. Next, type  control admintools  and click  OK . This will open the Windows Tools folder on your PC.

 156 Useful Run Commands To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard accwiz Add Hardware Wizard hdwwiz.cpl Add/Remove Programs appwiz.cpl Administrative Tools control admintools Adobe Acrobat (if installed) acrobat Adobe Designer (if installed) formdesigner Adobe Distiller (if installed) acrodist Adobe ImageReady (if installed) imageready Adobe Photoshop (if installed) photoshop Automatic Updates wuaucpl.cpl Bluetooth Transfer Wizard fsquirt Calculator calc Certificate Manager certmgr.msc Character Map charmap Check Disk Utility chkdsk Clipboard Viewer clipbrd Command Prompt cmd Component Services dcomcnfg Computer Management compmgmt.msc Control Panel control Date and Time Properties timedate.cpl DDE Shares ddeshare Device Manager devmgmt.msc Direct X Control Panel (if installed)* directx.cpl Direct X Troubleshooter dxdiag Disk Cleanup Utility cleanmgr Disk Defragment dfrg.msc Disk Management diskmgmt.msc Disk Partition Manager diskpart Display Pr...

 C:\Users\somet>reg query /? REG QUERY KeyName [/v [ValueName] | /ve] [/s]           [/f Data [/k] [/d] [/c] [/e]] [/t Type] [/z] [/se Separator]           [/reg:32 | /reg:64]   KeyName  [\\Machine\]FullKey            Machine - Name of remote machine, omitting defaults to the                      current machine. Only HKLM and HKU are available on                      remote machines            FullKey - in the form of ROOTKEY\SubKey name                 ROOTKEY - [ HKLM | HKCU | HKCR | HKU | HKCC ]                 SubKey  - The full name of a registry key under the                           selected ROOTK...

 Microsoft Windows [Version 10.0.22543.1000] (c) Microsoft Corporation. All rights reserved. C:\Users\somet>dir /? Displays a list of files and subdirectories in a directory. DIR [drive:][path][filename] [/A[[:]attributes]] [/B] [/C] [/D] [/L] [/N]   [/O[[:]sortorder]] [/P] [/Q] [/R] [/S] [/T[[:]timefield]] [/W] [/X] [/4]   [drive:][path][filename]               Specifies drive, directory, and/or files to list.   /A          Displays files with specified attributes.   attributes   D  Directories                R  Read-only files                H  Hidden files               A  Files ready for archiving                S  System files               I  Not content inde...

 Microsoft Windows [Version 10.0.22543.1000] (c) Microsoft Corporation. All rights reserved. C:\Users\somet>del /? Deletes one or more files. DEL [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names ERASE [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names   names         Specifies a list of one or more files or directories.                 Wildcards may be used to delete multiple files. If a                 directory is specified, all files within the directory                 will be deleted.   /P            Prompts for confirmation before deleting each file.   /F            Force deleting of read-only files.   /S            Delete specified files from all subdirectories.   /Q            Quiet mode, do no...

 Microsoft Windows [Version 10.0.22543.1000] (c) Microsoft Corporation. All rights reserved. C:\Users\somet>robocopy /? -------------------------------------------------------------------------------    ROBOCOPY     ::     Robust File Copy for Windows -------------------------------------------------------------------------------   Started : Wednesday, November 2, 2022 10:30:21 PM               Usage :: ROBOCOPY source destination [file [file]...] [options]              source :: Source Directory (drive:\path or \\server\share\path).         destination :: Destination Dir  (drive:\path or \\server\share\path).                file :: File(s) to copy  (names/wildcards: default is "*.*"). :: :: Copy options : ::                  /S :: copy Subdirectories, ...

  VBA Operators VBA uses a handful of simple operators and relations, the most common of which are shown in  Table 5-5 . Table 5-5. VBA Operators and Relations Type Name Symbol Arithmetic Operators Addition +   Subtraction -   Multiplication *   Division /   Division with Integer result \   Exponentiation ^   Modulo Mod String Operator Concatenation & Logical Operators AND And   OR Or   NOT Not Comparison Relations Equal =   Less than <   Greater than >   Less than or equal to <= or =<   Greater than or equal to >= or =>   Not equal to <> or >< The  Mod  operator returns the remainder after division. For example: 8 Mod 3 returns 2, since the remainder after dividing 8 by 3 is 2. To illustrate string concatenation, the expression: "To be or " & "not to be" is equivalent to: "To be or not to be"