b3e enter data insert web sheet / page as sheet / page Free Excel Macros (VBA) | Excel Programs

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Option Explicit

Dim bln As Boolean
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim wks As Worksheet
    Dim strName As String
    Dim rng As Range
    Dim StAr()
    Dim InI As Integer
    Set rng = Sheets("Eingabe").Range("B3") 'hier "Auslesezelle" für neuen TabBlattNamen anpassen
    If Target.Address = rng.Address Then bln = True
    If bln = True And Target.Address  rng.Address Then
        If Len(rng)  31 Then
            MsgBox "Bitte min. 1 und max. 31 Zeichen eingeben !"
            bln = False
            Exit Sub
        End If
        StAr = Array(":", "/", "", "?", "[", "]")
        For InI = 0 To UBound(StAr)
            If InStr(1, rng, StAr(InI), 0) > 0 Then
                MsgBox "Sonderzeichen ' " & StAr(InI) & " ' nicht zulässig !"
                bln = False
                Exit Sub
            End If
        Next InI
        For Each wks In ActiveWorkbook.Worksheets
            If UCase(wks.Name) = UCase(rng) Then
                MsgBox "Es existiert bereits ein Tabellenblatt mit diesem Namen !"
                bln = False
                Exit Sub
            End If
        Next
        Sheets.Add.Move after:=Sheets("Eingabe")
        ActiveSheet.Name = rng.Value
        Sheets("Eingabe").Select
        bln = False
    End If
End Sub

No	Macro Name
1	b3e enter data insert web sheet / page as sheet / page
2	inserts months as sheet / pages Specifies days in detail
3	inserts the date and time when data was entered into the cells where data was entered on the active sheet / page as a comment
4	Adds sheet / pages based on data in column A and writes data up to column D
5	number of sheet / page prints with message box (prints even if the sheet / page is blank)
6	excel operators hk
7	assigns date to the next line when data is entered in certain cells on the sheet / page
8	prints all sheet / pages with data or scans but does not print
9	inserts double zeros at the beginning of numbers entered in specific cells on the active sheet / page
10	automatic custom footer and header information on sheet / pages
11	warns and deletes data when data is entered in the active sheet / page
12	Add Multiple Worksheets: you can use this code if you want to add multiple worksheets in a single point in your workbook. When you run this macro code, you receive an input box to enter the total number of sheet / pages you want to enter.
13	the data in the cell appears as a footer on the other sheet / page
14	status bar macro with a message waiting
15	remove sheet / page protections
16	summer adds months to sheet / pages
17	specifies in detail how many references the book contains (on new sheet / page)
18	specifies in detail how many formulas are in the book (on new sheet / page)
19	list formulas on new sheet / page
20	Opening internet explorer in Excel

Excel Free Macros (VBA)

B3e Enter Data İnsert Web Sheet / Page As Sheet / Page

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords