Results 1 to 6 of 6

Call User form only if cell value is ""

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    17

    Thumbs up Call User form only if cell value is ""

    Hi Guys,
    I'm trying to call a user form from a range of cells only if cell value F3 is equal to "Shift B" I have the following in:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("N20:N47")) Is Nothing And Range("F3") = ("ShiftB") Then PickTechB.Show
    End Sub

    I have tried several combinations but am unable to find a solution, any help would be gratefully received.
    Regards
    Spagbog
    Last edited by Leith Ross; 07-20-2011 at 01:59 PM. Reason: Added Code Tags

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1