just enter numbers in the color cell: msgbox Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Aşağıdaki kodu aktif sayfaya yapıştırınız
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    Dim myRange As Range
    Dim intLowerlimit As Integer
    Dim intUpperlimit As Integer
    
    Set myRange = Range("A2:B5,D6:E8")  ' Sınırları yazın
    intLowerlimit = 1            ' istediğiniz alt limit
    intUpperlimit = 8            ' istediğiniz ust limit
    
    If Not Intersect(Target, myRange) Is Nothing Then
      If Not IsNumeric(Target.Value) Then
        MsgBox ("Sadece rakam girebilirsiniz!")
        Cells(Target.Row, 6).Value = "Rakam değil!"
        Cells(Target.Row, 6).Font.Color = RGB(255, 0, 0)
      ElseIf Not (Target.Value / 1 = Target.Value  1) Then
        MsgBox ("Geçerli değil")
        Cells(Target.Row, 6).Value = "Dogru degil"
        Cells(Target.Row, 6).Font.Color = RGB(255, 0, 0)
      ElseIf Target.Value  intUpperlimit Then
        MsgBox ("Sayı ust limitten fazla! " _
              & intLowerlimit & " and " & intUpperlimit)
        Cells(Target.Row, 6).Value = "Sayı limit değeri ustunde!"
        Cells(Target.Row, 6).Font.Color = RGB(255, 0, 0)
      Else
        Cells(Target.Row, 6).Value = "Dogru"
        Cells(Target.Row, 6).Font.Color = RGB(0, 255, 0)
      End If
    End If
End Sub

No	Macro Name
1	just enter numbers in the color cell: msgbox
2	excel operators hk
3	just entering numbers in the textbox
4	delete duplicate / duplicate rows
5	Print Custom Pages: You can use this code to print a range of custom sheet / pages instead of using the setting from the print options. Suppose you want to print sheet / pages 5 to 10. Just run this VBA code and enter the start sheet / page and end sheet / page.
6	write the number you want to be colored on the sheet / page in msgbox
7	convert double and single lines into different colors and designs (one line is bold and the other line is normal)
8	Multiply All Values by Number: You have a list and you want to multiply the entire number by a specific number. Just use this code. Select this range of cells and run this code. first, it will ask you the number you want to reach more than one person, and then all their numbers will be multiplied instantly.
9	just enter a period or comma in the textbox
10	Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for.
11	search color
12	It is not compulsory to enter numbers in cell a1 or switch to other cells is forbidden
13	Adding Serial Numbers: This macro code will help you automatically add serial numbers to your excel sheet. After you run this macro, it will display an input box where you must enter the maximum number for serial numbers, and then add a number to the column in a column.
14	Create a user-defined menu / Create your own menu and assign a macro to them in the "Extensions" section
15	Find and select the remaining cell in the value between 2 selected numbers
16	specifies in detail how many formulas are in the book (on new sheet / page)
17	list formulas on new sheet / page
18	Number / Highlight Cells that Error in the entire worksheet: This code will help you to highlight and count all the cells you have made an error with. Just run this code and it will return a message containing the number error cells and will highlight all the cells.
19	Use Target Seek: Target Seek can be super to solve complex problems. Learn more about destination search here before using this code.
20	calculator on / off

Excel Free Macros (VBA)

Just Enter Numbers İn The Color Cell: Msgbox

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords