+ Reply to Thread
Results 1 to 7 of 7

Macro Add row & add values in 2 different textbox

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2010
    Posts
    99

    Macro Add row & add values in 2 different textbox

    Attachment 195216Hi user's of excel forum!!

    Good Afternoon!

    I have a problem with add row & insert new values in textbox's
    I try to move the select cell to headers "Secondary VALUE" & "Quantity", but this move to other cells and don't stop.

    Attach the workbook and this is the code that I use:TEST PRICING TOOL.xlsm

    For ADD button:
    Please Login or Register  to view this content.

    For TEXTBOX's:
    Please Login or Register  to view this content.
    Best Regards!!
    Last edited by feroguz; 11-20-2012 at 05:19 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Macro Add row & add values in 2 different textbox

    Can you better explain what you are trying to do and what the problem is?

  3. #3
    Registered User
    Join Date
    06-06-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Macro Add row & add values in 2 different textbox

    Dear Sr:

    I require that the listbox2 & listbox3 are selected in cell "D" (Secondary Header VALUE) and "F" (Header Quantity Value) to add the new values ​​..

    The error that I have, is that only add function to find an empty value in the cell "D" but doesn't work the another function in value "F":
    This:
    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Macro Add row & add values in 2 different textbox

    This adds the values to the next empty row in columns D and F when you click the command button. Is that what you want?

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 11-20-2012 at 07:44 PM. Reason: typo

  5. #5
    Registered User
    Join Date
    06-06-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Macro Add row & add values in 2 different textbox

    Hi Alphafrog:

    this function
    Please Login or Register  to view this content.
    Is in the button of the application or in other section??.. because don't work me
    Other idea?

    Best Regards!!

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Macro Add row & add values in 2 different textbox

    It's in the newc userform code module.

    Sorry,it should be this...

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 11-20-2012 at 08:35 PM.

  7. #7
    Registered User
    Join Date
    06-06-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Macro Add row & add values in 2 different textbox

    Dear AlphaFrog:

    I remplace the code, because when performing this code the value added at the bottom of the sheet.

    Modify the code for this:

    Please Login or Register  to view this content.
    And it works great!

    Attach the new worksheet for share:

    I have to thank you for always helping me, this is the second time.
    Thread closed
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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