+ Reply to Thread
Results 1 to 6 of 6

VBA Show Ribbon Form for Table

  1. #1
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    950

    VBA Show Ribbon Form for Table

    Hi,

    Is there code that will show the standard form from the ribbon for a table?

    I have the cursor in one of the table cells.

    My research so far leads me to believe this is not possible.

    Thanks
    Last edited by billy60; 10-05-2023 at 05:15 PM.

  2. #2
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    950

    Re: VBA Show Ribbon Form for Table

    I found another way without the use of forms.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,434

    Re: VBA Show Ribbon Form for Table

    Please share the solution. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    950

    Re: VBA Show Ribbon Form for Table

    Yes of course. I created different sheets for the Customers and Paint Detail. These sheets have specific cells that populate from the list of details with codes to Save, Add New, Cancel New, and Delete. I put GoTo codes from the Copysheet to add or edit the Customers or Paints. Then as I make extra Job sheets of course these will be copied over.

    Please see attached.
    Attached Files Attached Files

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,434

    Re: VBA Show Ribbon Form for Table

    Thank you.

  6. #6
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    950

    Re: VBA Show Ribbon Form for Table

    You're welcome!

    I appreciate everyone's help.

+ 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. Show Custom Tab Ribbon in Certain Workbook
    By kal0123456789 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2022, 01:06 PM
  2. [SOLVED] Macro to Show/Kill Form Formatted Data Table
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2018, 07:08 AM
  3. vba to show pivot table in tabular form
    By yossip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2017, 05:34 AM
  4. [SOLVED] show filename below the ribbon
    By ntambomvu in forum Excel General
    Replies: 7
    Last Post: 07-10-2015, 12:08 PM
  5. How Do I Show Titles to Icons on Ribbon?
    By omaral in forum Excel General
    Replies: 1
    Last Post: 12-31-2014, 06:38 AM
  6. Show Table Data in Printable form
    By sjennings007 in forum Excel General
    Replies: 10
    Last Post: 01-03-2014, 06:50 PM
  7. Show table with grid lines in a user form
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2009, 03:58 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