+ Reply to Thread
Results 1 to 2 of 2

Command Button to Disappear after a couple of seconds

Hybrid View

  1. 07-23-2012, 02:42 PM #1
    michaeljoeyeager
    michaeljoeyeager is offline
    Registered User
    Join Date
    06-12-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    54

    Command Button to Disappear after a couple of seconds

    Friends,

    I have a CommandButton that appears to the right of a selected cell...

    ElseIf Not Application.Intersect(Target, Range("A6:A1048576")) Is Nothing Then

    If Not Target.Value = "" Then
            
        Set r = Target
        
        CommandButton2.Left = Target.Offset(0, 1).Left
        CommandButton2.Top = Target.Top
        CommandButton2.Visible = True
    How can I get that button to dissapear after 2 seconds?

    Thanks in advance,

    -Mike
    Reply With QuoteRegister To Reply
  2. 07-23-2012, 03:33 PM #2
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: Command Button to Disappear after a couple of seconds 

    If Not Target.Value = "" Then
            
        Set r = Target
        
          CommandButton2.Left = r.Offset(0, 1).Left
          CommandButton2.Top = r.Top
          CommandButton2.Visible = False
        Application.Wait DateAdd("s", 2, Now)
          CommandButton2.Visible = True
        End If
    Harry.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1