Results 1 to 6 of 6

Command Button - VBA To Insert Table Row not copying Table Format for Percent

Threaded View

kcampb8965 Command Button - VBA To... 09-01-2021, 07:24 AM
torachan Re: Command Button - VBA To... 09-01-2021, 07:34 AM
kcampb8965 Re: Command Button - VBA To... 09-01-2021, 07:48 AM
torachan Re: Command Button - VBA To... 09-01-2021, 09:09 AM
kcampb8965 Re: Command Button - VBA To... 09-01-2021, 09:37 AM
kcampb8965 Re: Command Button - VBA To... 09-02-2021, 06:27 AM
  1. #1
    Registered User
    Join Date
    08-26-2021
    Location
    St. Louis, MO
    MS-Off Ver
    2016
    Posts
    15

    Command Button - VBA To Insert Table Row not copying Table Format for Percent

    The attached sample is from a much larger workbook that includes multiple tables and a user form to populate the main database. I have inserted a table on the dashboard with a command button to insert a row. The VBA code is simple enough and a row is properly added when executed. The problem is, the column with a percentage format is being copy with a $ format instead of a % format. I copied the range to a table and reinput the formulas and formats in the first row and reconverted it to a table, but the issue persists.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete Table Row command button
    By DropAGearN'Disappear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2021, 12:37 PM
  2. [SOLVED] Copying ActiveX Command Button from master sheet to subsheets. command button code missing
    By popper08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2020, 10:15 AM
  3. Command button to insert row at intersection in a table
    By Georgethethird in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2015, 06:09 PM
  4. How To Colour a cell in a table using command button
    By souharda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2014, 01:52 AM
  5. [SOLVED] Link command button to row in table
    By r2fro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2013, 10:22 AM
  6. [SOLVED] How to make a Command button run the "FORM" command to fill/populate a table?
    By jrobin7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2012, 12:26 PM
  7. Cycle Through Table Data Using a Command Button
    By bennon05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2012, 02:28 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