+ Reply to Thread
Results 1 to 6 of 6

Input in textbox from right to left with comma positioning

  1. #1
    Registered User
    Join Date
    11-01-2022
    Location
    venezuela
    MS-Off Ver
    365
    Posts
    10

    Lightbulb Input in textbox from right to left with comma positioning

    Greetings code warriors, I will try to be as explicit as possible, for months I have been struggling with a code without success, I am trying to create a textbox code that allows me to enter the digits from right to left, and in the second digit place a comma automatically concatenated with the unit of "Kg". Below I leave a description of what was requested, I hope someone can help me



    Here is the code with which I have been working

    Captura de pantalla 2023-01-28 203303.png


    Please Login or Register  to view this content.


    The problem arises every time I press a button in the textbox an event is activated that simulates that I have pressed the button many times below, I leave an image of the error, for example here I press the eight once and see what happens

    Captura de pantalla 2023-01-29 030955.png
    Last edited by kapela; 01-29-2023 at 03:48 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,607

    Re: Input in textbox from right to left with comma positioning

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    11-01-2022
    Location
    venezuela
    MS-Off Ver
    365
    Posts
    10

    Re: Input in textbox from right to left with comma positioning

    Greetings Bro, thanks for taking some time and answering my question, I inform you that the code you gave me generates an error when deleting and increasing the length of the string, and the one I use generates overflow, I will be attentive to any correction.. .

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,607

    Re: Input in textbox from right to left with comma positioning

    1. Are you saying that you are pressing 'delete' after pressing a number key because you made a mistake and want to reenter a new digit.
    Post a sample file (with code).

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: Input in textbox from right to left with comma positioning

    Your whole concept is doing this the hardest way possible. You should have one textbox where you input only numbers, then that is formatted for display in another box.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  6. #6
    Registered User
    Join Date
    11-01-2022
    Location
    venezuela
    MS-Off Ver
    365
    Posts
    10

    Re: Input in textbox from right to left with comma positioning

    My dear friend 6StringJazzer, I'm sorry for not having answered you sooner, I had serious health problems with the covid19, which caused me to be absent, I actually checked your workbook and exactly what I described, the detail would be that I need it, but my question is if it is necessary make use of an input texbox so that it is manifested in that way in the other, that is, to do it directly in the textbox without the use of auxiliaries, thanks in advance

+ 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] How open a worksheet to a specific cell in left corner for positioning purpose?
    By RonRich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2013, 08:30 AM
  2. input the value of a Combobox and a textbox to a TEXTBOX directly from a userform
    By Gordonhk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 03:25 PM
  3. Find and remove all text to the left of last comma (including comma) in a cell
    By Excelrookie_1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2013, 08:47 AM
  4. Positioning of textbox
    By MarcoAUA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2012, 01:51 PM
  5. left to first or second comma
    By terrysoper1973 in forum Excel General
    Replies: 5
    Last Post: 09-08-2011, 08:13 PM
  6. Use textbox input and VLookup to update another textbox on same userform
    By gcoug in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2011, 10:39 AM
  7. Positioning of validation input message
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2009, 05:52 PM
  8. Positioning a cell at the top left of the screen
    By Ben in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2005, 09:07 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