vba if then statement

What is the VBA language?Believe that the user read this article should know what is VBA, here or briefly, Visual Basic for Applications (VBA) is a macro language of Visual Basic, is developed by Microsoft to perform common automation in its desktop applications ( OLE) task's programming language. Application features that are primarily used to extend Windows, es

001 -- On Error in common VBA commands) Everyone wants their programs to be smooth, but errors have always been a pain point in our hearts. We always jump out from time to influence our mood. Although the hop-out error prompt will interrupt the running of our program Just like our painful sensory nerves, it is a protection. It can avoid incorrect results or even catastrophic consequences. We can further program design and improvement to avoid errors a

You can create 4 auto-run macros in standard modules in Excel, which are Auto_Open (run automatically when you open the workbook), Auto_Close, Auto_Activate, Auto_Deactivate. These autorun macros are reserved for compatibility with EXCEL5 and 95. You can now replace them with the Open,close,activate,deactivate event of the workbook.So, what is a "standard module"? In fact, the module we inserted in the VBE, Microsoft called it a "standard module." While the rest of the three categories: Microsof

China localization Pack is a piece of chicken,But for some friends it is not true;Unfortunately, the exit of China's localization package has lagged behind,More than 1 years after the latest version of the software came out,Localization is not sure to come out,Even if it comes out,It can only be obtained by users who have purchased a fast Bo service.In the 2017 release of the localization pack,Contains some 2009 versions of the VBA source code,Althoug

the text box was automatically cleared after the scanner was entered, but the focus went to the next button. Cause If you are not careful, manually use the SetFocuse method to set the text box to get the focus.1 Private Sub TextBox1_KeyDown (ByVal KeyCode As MSForms. ReturnInteger, ByVal Shift As Integer) 2 If KeyCode = 13 Then 3 TextBox1.Value = "" 4 TextBox1.SetFocus 5 End If 6 End Sub The program runs again, and the focus is still on the button. No wonder the SetFocus method does not wor

The following is an example of using Excel VBA to connect to Oracle and operate Oracle-related data.To connect to the database through VBA, Excel needs to install the corresponding Oracle client tool and reference the relevant components of ADO. to reference the components of ADO, follow these steps:1. Open the VBA editor and click "Tools" and "Reference" in the

= Mat. Item (1). Value case Else MsgBox ("Incorrect input") end Select End FunctionCode Explanation:1, rng as Range, Name: Pass two parameters, the first parameter is a cell parameter.2, application.volatile Set regx = CreateObject ("VBScript.RegExp"): Create regular Expression object, fixed syntax.3. With REGX. Global = True. Pattern = "[\u4e00-\u9fa5]+"Set mat =. Execute (RNG)End withGlobal: Indicates whether to retrieve globally, and true indicates

) To force a line break in a message, use the vbCrLf (or vbNewLine) constant in the text, separated by A space and a character. Such asMsgBox "The first line." vbNewLine "Second line."(6) You can insert a tab character in a message box using the Vbtab constant. The following procedure uses a message box to display all values in a 5x5 range of cells, separates columns with Vbtab constants, and inserts a new row using the vbCrLf constant. Note that the MsgBox function displays up to 1024 charac

"Kernel32" _(ByVal CodePage as Long, ByVal dwFlags as Long, lpwidecharstr as Integer, ByVal Cchwidechar as Long, _Lpmultibytestr as Byte, ByVal Cchmultibyte as Long, ByVal Lpdefaultchar as String, ByVal Lpuseddefaultchar as Long) as Lon G?4. Expansion①ptrsafehttps://msdn.microsoft.com/en-us/library/office/gg278832.aspx?f=255MSPPError=-2147217396Declare statements with the Ptrsafe keyword is the recommended syntax. Declare statements that include ptrsafe work correctly in the VBA7 development en

When Office users need to customize new features for a document, they can resort to VBA or two ways of VSTO. Office 2013 Rich Client, Microsoft provides a new model for developers on the Office platform---Office add-in model, which allows you to create an area in an Office application and show the Web pages interacting with the document in this area. Developers can integrate highly customized WEB apps or services into office, making them available on

Transferred from Http://www.cnblogs.com/wangminbai/archive/2008/02/22/1077203.html We all know that pointers can be used in C, but now VB (of course there are VBA) can also be used as pointers. This is an article I have read on the internet for your reference.Think that the East is undefeated, black Cliff secret room battle, only with a embroidery needle fight four Masters alone, no ghost, called the world's first martial arts. If you want to become a

Range (Rows (3), rows (5)). Insert Shift:=xldown1) Insert a row at the current cell ; You can add a loop statement to insert multiple rowsRange ("A10"). SelectSelection.EntireRow.Insert, Copyorigin:=xlformatfromleftorabove2) Insert the same number of rows at the current selection row as the number of rows to select, and change the line number to insert in different places. Rows ("10:11"). Select Selection.insert Shift:=xldown, Copyorigin:=xlfor

Sometimes, when using Word for text editing, suddenly encountered power, or computer automatic shutdown, crash, and other failures, resulting in the work of hard to do out of all the results, is a lot of netizens are very crazy things. Today, I'm going to teach you. Use VBA code to automate backup so that Word can be automatically backed up every few minutes without affecting the file being edited. Let's get to know each other now! 1, open the Word F

Overview: It mainly describes the usage and disadvantages of VBA, and then explains how to set up the development environment of VBA and how to improve programming efficiency by using VBE. I. A Brief History of VBA A) macro introduction: The macro should be named macro. It is a set of commands that automatically execute certain operations. It contains two process

Recently, I was too busy to do some things with my mind. The progress of an Excel book was very slow. The reason was that I could not concentrate on doing things, except for the outside world. Today, a Web user sent a mail to discuss the VBA issue. I wonder if the platform after office 12 or later will continue to support VBA. I replied that it should continue or there is a better alternative. But in fact

Failure Analysis: Excel VBA is in fact Everyone Code Editor program, some people are considered to be macros, but Excel VBA is included in the macro program. Let's take a look at what Excel VBA is. How do I open it? One, Excel VBA is what? VBA in Excel