Results 1 to 2 of 2

Spinner VBA

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2014
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    37

    Spinner VBA

    Im trying to use a spinner to change cell value this change in value initiates VBA then conditional operator 'IF' based on the cell in question. Code works fine when value is entered into cell but not when spinner changes value of the cell. Any ideas?

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim KeyCells As Range
    
    Set KeyCells = Range("N3")
    
    If Not Application.Intersect(KeyCells, Range(Target.Address)) Is Nothing Then
    
        If Range("N3") = 2 Then
    Last edited by silkpantsman; 07-14-2015 at 06:10 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Increase Max Value of Spinner
    By Lon in forum Excel General
    Replies: 6
    Last Post: 10-18-2017, 11:16 PM
  2. Spinner Problem
    By JayM101 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2013, 09:45 AM
  3. Excel 2007 : Add a Spinner
    By cd3atm in forum Excel General
    Replies: 1
    Last Post: 11-03-2010, 12:13 AM
  4. Spinner and Dates
    By cybercab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2006, 01:39 PM
  5. Can you hide a spinner???
    By shnim1 in forum Excel General
    Replies: 1
    Last Post: 03-23-2006, 04:55 PM
  6. [SOLVED] Spinner functionality
    By mellowe in forum Excel General
    Replies: 2
    Last Post: 01-23-2006, 09:20 AM
  7. [SOLVED] Spinner
    By Maureen in forum Excel General
    Replies: 2
    Last Post: 05-23-2005, 10:06 AM
  8. [SOLVED] Spinner-requiring Spinner buttons
    By Greg Robinson via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2005, 07:34 PM

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