+ Reply to Thread
Results 1 to 4 of 4

NEWB ActiveX Question

  1. #1
    Registered User
    Join Date
    05-08-2016
    Location
    Pennsylvania, USA.
    MS-Off Ver
    2010
    Posts
    2

    NEWB ActiveX Question

    Hello, I'm trying to assign a recorded macro to an ActiveX Control button. (I hope I'm explaining what I need correctly.)

    I want an activex button to change the background color of a selected cell(s) when you click it.



    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: NEWB ActiveX Question

    You don't 'Assign' a macro to an ActiveX button, you add code to the button Click event.

    Add a button to the worksheet then go to the sheet code module, use the dropdown top left to display the events for the button and select the Click event from the deposited on the right.

  3. #3
    Registered User
    Join Date
    05-08-2016
    Location
    Pennsylvania, USA.
    MS-Off Ver
    2010
    Posts
    2

    Re: NEWB ActiveX Question

    Could you give me an example of the code? I'm extremely new to excel.

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: NEWB ActiveX Question

    You simply add your macro name.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro/VBA Question - Newb
    By wmccourt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2014, 12:19 AM
  2. split data newb question
    By tarpitman111 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-02-2014, 08:23 AM
  3. Newb question/User forms
    By AndrewWheeler87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 11:28 AM
  4. Newb question about charting data
    By rippledj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2012, 06:07 AM
  5. Super newb question
    By sbob in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-05-2006, 11:12 PM
  6. Extreme newb, easy question: Simple button/scrollbar coding
    By BlackSeaBandit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2006, 12:18 AM

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