Results 1 to 2 of 2

Thread: Show userform based on cell value
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,586
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Show userform based on cell value

    Currently not at my pc but I would like a userform to only be shown if a specific cell is empty.


    Would this be correct ?

    Please advise.




    Code:
    If Cell (B1) =  Then
    Userform1.Show
    Else
    Exit sub 
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

  2. #2
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,586
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Show userform based on cell value

    I think it should be,

    Code:
    Private Sub Worksheet_Activate()
    If Range("B1") = "" Then
    Userform1.showElse
    Exit Sub
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

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
  •