| klste@hotmail.de |
1_ Use macros to create Excel workbook. Display language german.
With the help of macros in Excel to automate various processes, allow or limits, to extend the available Excel functionality. In Excel 2010 workbooks with macros should be extra created and stored.
2_ Write and run simple macro.
Macros are written in the Visual Basic Editor (VBA Editor) and executed.
3_Create a simple message box (MsgBox).
Easiest way in Excel to print a message on the screen, is the message box (MsgBox).
4_Create an input mask (UserForm) in Excel VBA and can do.
With an input mask (UserForm) can register easily different data in certain spreadsheets.
5_Call a User Form in Excel VBA form with shortcut key.
You can find form (User Form) in Excel VBA with keyboard shortcut. First, the macro is recorded.
6_Insert Excel VBA in the toolbar controls and design mode.
2 Commands will be added to the toolbar: „Steuerelemente einfügen“ ("add controls") and „Entwurfsmodus“ ("Design mode"), these are very important elements in Excel VBA programming.
7_Paste it into Excel command button and wreak.
To activate input mask, a command button is inserted, formatted and programmed.
8_For simple database in Excel VBA create input mask.
Simple database has two columns: "Month", "Sales". For this reason, the input mask should have two labels, two text boxes and a command button.
9_ For a database in Excel VBA programming input mask.
Simple database has two columns: "Month", "Sales". For this reason, the input mask should have two labels, two text boxes and a command button. The registration of data begins with the first text box "Month" and ends with pressing the command button "Enter".
10 On Error GoTo jump brand in Excel VBA.
Entry of data into the database is not always perfect, can it happen error, for example instead of a number, text is entered. Why should a label fitted. "On Error GoTo Final " instead of " Final " you can use another term. Before the label the procedure with exit to Exit Sub, because otherwise she will step through code after the jump directly in any case.
11_ On error resume next instruction in Excel VBA.
With the introduction of “On Error Resume Next” error will be passed and the sequence of the procedure will be continued in the next line of code. The instruction is very useful if from a text box, text or number to be registered.
12_Create serial number in Excel database.
The consecutive numbering of entries into an Excel database is an important element to keep neat and well-arranged data collection.
13_In Excel databases an entry, find and change.
Incorrectly written an Excel database entries searched, found, and changed.
14_ Event Private Sub TextBox1_Change() Excel VBA programming
The consecutive numbering of entries in a database is an important element to keep neat and well-arranged data collection.
The text field of an input mask, which is responsible for the sequential number, better programming that is found when you enter a number in the box, the sequential number in the database and all components of the entry in all other fields of the form are visible.
The code should be in the change event of the field, because after each change of code will be executed immediately in the event.
15_ Event private Sub_Enter()_Private Sub_Exit()_Excel VBA programming
The text field of an input mask, which is selected (event Private Sub TextBox1_Enter()), better with a different background color mark and leave it if (event Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)), to have the text box again white background color.
With guard you can protect individual cell contents or the entire sheet. In Excel VBA, the blade guard with a macro is enabled or disabled.
17_InputBox, input box in Excel VBA. Display language german
In Excel VBA an InputBox, input box provides a line of input. You can transfer the value in the command window, enter the box on worksheet.
18GS_Delete an entry in the database.
In an Excel database, there are many entries, some of which are incorrect or out of date. Better to remove such entries from the database. It's very easy to delete an entry in Excel VBA.
19GS _ Excel workbook for the network share
Excel files in a network should be released first, only then can several users who edited.
20GS_ Delete all entries in database
There are such Excel databases, where and all entries should be deleted. It's very easy to delete all entries in Excel VBA.
21GS_ Insert a picture in Excel database
Excel databases, which contain images, are significantly more meaningful than those who have no pictures. Insert a graphic in the Excel data sheet is very easy.
22GS_Create with Cyrillic letters in Excel VBA and display lyrics
In Excel application with default language German, creating works display texts in the VBA Editor in English, Spanish or French language very well, because the font is the same.
With Cyrillic letters, it will cause problems, E.g. button instead of Cyrillic letters will be just like that: öáé???.
To resolve this problem, you must first change the default input language for the Windows operating system in Russian language.
Under Windows7, click Start, Systemsteuerung, Zeit, Sprache und Region, Region und Sprache, Formate.
Under the „Format:“ select „Russisch (Russische Föderation)“.
When display text in button is still wrong, you should find appropriate language pack on the Internet and download, it takes a long time, but, if everything is installed, Cyrillic, in VBA controls, is displayed correctly.