+ Reply to Thread
Results 1 to 2 of 2

create control button and assigning it a macro

  1. #1
    Registered User
    Join Date
    Chadds Ford, PA, USA
    MS-Off Ver
    Excel 2010

    create control button and assigning it a macro

    1. I am trying to write a new macro to create a control button in the first cell of the first empty column not already populated by a previously created control button.

    2. Then I want to assign the new control buttons to already existing macros

    im currently using: Set LastCol = Range("A1").End(xlToRight)
    to find the last unused column, but it does not register the exisiting buttons as populating the cells and i get an error
    "run-time error 1004: application-defined or object-defined error" likely because the cells do not contain regular data

    any and all help is welcome. thanks

  2. #2
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    MS-Off Ver
    Excel 2003 & 2007

    Re: create control button and assigning it a macro

    Hi ers,

    Welcome to the forum.

    Please can attach your Excel file as it will be easier and will let us experiment with your data, formulas, and code.


    Bonny Tycoon

    Please consider:

    1. Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    2. Mark your thread [SOLVED] if you received your answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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