+ Reply to Thread
Results 1 to 3 of 3

General assistance needed using VAA for Excel

  1. #1
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Question General assistance needed using VAA for Excel

    Question 1: What is the most quickest way to mark my code within a modsheet as a comment?
    Question 2: I've added a button to an Excel spreadsheet but where do I find the properties for that button? I found that I could find properties for buttons added to a userform but not buttons added directly to a spreadsheet.

    Thanks so MUCH for you generous assistance!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: General assistance needed using VAA for Excel

    1) In VBE: Make sure View->Toolbars->Edit is checked (if not, after checking it will become visible - possibly outside of VBE window. drag it next to standard toolbar)
    Select all lines of code to be commented and click Comment Block button on this toolbar. Note that next to it there is Uncomment Block button.

    2) it depneds whether it is a form button or activeX button Basically - try to access it with right-click (in case of ActiveX - click first on Design Mode).
    Attached Images Attached Images
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Re: General assistance needed using VAA for Excel

    Hi Kaper,
    Thanks so much for taking the time to reply to my post. I did eventually get the Comment/UnComment block added to my toolbar and working great! THANK YOU

    The properties for the button on my Excel worksheet is still in hiding. I took a screen shot to show you the drop down menu that appears after I right click the button and the properties just for the worksheet when I tried Developer and the properties selection.

    You asked about if it was a form button or an activeX. I selected the form button from the toolbox for my spreadsheet. Maybe those can only be used with macros and not code??? I don't remember anything about using macros for controls so if that's true, I'll need to do some research to learn how to program the control without code.

    Please let me know if this sparks any ideas as to where I SHOULD be looking for the button properties. Also, maybe you can please let me know if I'm trying to write code for a button that will only accept commands from a Macro.

    Thanks again for your time.
    Attached Images Attached Images

+ 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. [SOLVED] Assistance Needed Formatting Autocad to Excel Lisp Routine
    By Jim Clayton in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-21-2018, 12:09 PM
  2. Excel Assistance Needed - Counting Number of Instances
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-04-2016, 04:34 AM
  3. Urgent assistance with Excel needed, help me get a job:)
    By Ge0or in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2016, 09:02 PM
  4. Assistance needed to loop code when pulling info from a web page and pasting to excel
    By boswelljw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2015, 09:49 AM
  5. Macro assistance needed for complex export/import excel file
    By dedavie in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-28-2013, 02:47 PM
  6. Replies: 12
    Last Post: 05-14-2010, 10:25 AM
  7. Assistance needed with drop downs in excel 2007
    By wooley2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2010, 04:35 AM

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