Results 1 to 4 of 4

Thread: Give error/msgboxbox if cell hasent had any values for x times when clicking a button
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2018
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Give error/msgboxbox if cell hasent had any values for x times when clicking a button

    Hi.

    Is there a good way to make it so that if i click a button, the code will check if a spesific cell has had any values in the last 10 times (10 is just an example), and if it hasent, a error message /msgbox will appear?

    Example.

    Lets say A1 is the cell i want to check, and a button with some code that is going to run if i click it, then lets say if i fill the cell with a value, my normal code will run as normal, but if there has been no entries in that cell for 10 clicks on that button, a message will appear.

    Thanks in advance

  2. #2
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,049
    Post Thanks / Like
    Mentioned
    35 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Give error/msgboxbox if cell hasent had any values for x times when clicking a button

    Try something like this:

    Code:
    Dim x As Long
    Private Sub CommandButton1_Click()
        If Range("A1").Value = "" Then x = x + 1 Else x = 0
        If x >= 10 Then MsgBox "It's empty"
    End Sub
    'Dim x As Long' must be placed at the top of the module.

  3. #3
    Board Regular
    Join Date
    Jun 2018
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Give error/msgboxbox if cell hasent had any values for x times when clicking a button

    Hi.
    Thanks alot. this worked perfectly!

  4. #4
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,049
    Post Thanks / Like
    Mentioned
    35 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Give error/msgboxbox if cell hasent had any values for x times when clicking a button

    You're welcome, glad to help, & thanks for the feedback.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •