+ Reply to Thread
Results 1 to 3 of 3

Unable to delete numbers in table

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2019
    Posts
    57

    Unable to delete numbers in table

    I have a Userform which have a list display of the items in table. The code below is used to delete the selected row in the table. I am able to select and delete items with alphabets. However, when I tried to select and delete pure numbers, the variable
    Please Login or Register  to view this content.
    appears to be false despite the numbers appear in the list display. I suspect the problem comes from
    Please Login or Register  to view this content.
    . Kindly guide me to the right direction. Thanks.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: Unable to delete numbers in table

    You probably need to coerce the numeric text to a real number using something like CLng(Me.lstDisplay.Value)
    Rory

  3. #3
    Registered User
    Join Date
    09-20-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2019
    Posts
    57

    Re: Unable to delete numbers in table

    Hello rorya,
    Is it possible to set it so that it could delete both alphabets and numbers?
    Thanks.

+ 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] Unable to Delete Table Rows
    By omagoodness in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-27-2019, 04:53 PM
  2. [SOLVED] Unable to delete Row
    By King Mustard in forum Excel General
    Replies: 2
    Last Post: 11-22-2019, 12:03 PM
  3. Delete table rows where a cell in D contains certain numbers
    By victormiyagi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2017, 03:57 PM
  4. [SOLVED] Delete entire row in table if cell in column P contains any value (numbers or text)
    By BuntyMac in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-29-2016, 02:49 PM
  5. Replies: 3
    Last Post: 11-08-2012, 07:25 PM
  6. unable to delete a line
    By nabilqu in forum Excel General
    Replies: 1
    Last Post: 01-30-2008, 10:03 AM
  7. Unable to delete worksheet
    By hazrd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2007, 10:42 PM

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