Results 1 to 2 of 2

Toggle Button VBA Handler macro

Threaded View

re0 Toggle Button VBA Handler... 12-02-2013, 01:40 PM
Leith Ross Re: Toggle Button VBA Handler... 12-02-2013, 07:51 PM
  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    ontario
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Toggle Button VBA Handler macro

    I have about 100 toogle btns.
    Can i feed the togle btn number and the corresponding "b" value to a "handler" vba code?

    below is my code

    Sub ToggleButton3_Click()
    
        If Sheets("List").OLEObjects("ToggleButton3").Object.Value = True Then
            
            Sheets("Internal Quote").Range("A8:F8").End(xlDown).Offset(1, 0).Value = Sheets("List").Range("B3").Value
             
        End If
    
    End Sub
    Last edited by Leith Ross; 12-02-2013 at 06:24 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Toggle Button, Macro Off/On Help
    By ike609 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2012, 09:27 AM
  2. [SOLVED] macro to copy toggle button & behaviour
    By connieb in forum Excel General
    Replies: 2
    Last Post: 07-03-2011, 04:14 AM
  3. Toggle Macro on Button
    By Baziwan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-05-2010, 01:08 PM
  4. Macro in a Toggle Button
    By Preatorian in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2009, 09:20 AM
  5. [SOLVED] Recording Macro, toggle absolute/relative reference, button disapp
    By Kayos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2005, 04:05 PM

Tags for this Thread

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