+ Reply to Thread
Results 1 to 3 of 3

Numeric to text change in Dynamic Table Excel 2013

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    kettering,england
    MS-Off Ver
    Excel 2010
    Posts
    4

    Numeric to text change in Dynamic Table Excel 2013

    I have a Dynamic Table in excel 2013. The date is entered into the Table by a Userform. All ok until I add the 2nd record into the Table. All the numeric values in the second record are being stored as text values. If I add a 3rd record these values remain as numeric but my Table stops being Dynamic. Can anyone explain how to stop this happening?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Numeric to text change in Dynamic Table Excel 2013

    When you manually add a row to the bottom of a table, Excel is smart enough to include it in the table. In VBA, Excel believes you know what you want to do, so adding the values directly beneath the table is exactly what Excel does and it does not expand the table. Here is what you need to modify in your CmDAccept_Click() subroutine:
    Please Login or Register  to view this content.
    P.S. Please, for the sanity of the user, remove the "Are sure this is the right player" and "Are you sure this is the right day" prompts. After doing it twice I had to disable it, and it won't help after a person has done it more than 10 times because then they just get in the habit of hitting Yes.
    Last edited by Pauleyb; 03-12-2015 at 04:31 PM.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Registered User
    Join Date
    03-07-2013
    Location
    kettering,england
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Numeric to text change in Dynamic Table Excel 2013

    Cheers Pauley
    {Solved}
    You have solved my issue.
    Regards

    Andy

+ 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. Change Pivot Table Column field on Slicer selection (Excel 2013)
    By kevboyo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-27-2014, 11:36 PM
  2. [SOLVED] Excel 2013: Change text in cell based on date in another cell
    By LisaJean in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2014, 08:22 AM
  3. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  4. Text as value in pivot table . is that possible in excel 2013
    By onenessboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 08:37 AM
  5. Convert Text to Numeric Excel 2010 Pivot Table
    By zcheema in forum Excel General
    Replies: 1
    Last Post: 05-17-2012, 04:58 PM

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