+ Reply to Thread
Results 1 to 3 of 3

VBA to copy multiple Text boxes values to a sheet

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    VBA to copy multiple Text boxes values to a sheet

    Dear Friends / Experts

    I have a excel workbook & i want to do copy multiple text boxes (5,6,11,17,23,29,35,41,47,53,59,65,71) values to a sheet, but value should be copied based on combo boxes text to column E & text boxes value should be added in existing value ( for example if existing value is 10 & present value is 5 then column E value = 15)

    Please see attached workbook for further details it's self explanatory.

    Thanks in advance

    Sagar007
    Attached Files Attached Files
    Last edited by sagar007; 01-18-2013 at 02:38 AM.
    Sagar
    Arise awake & stop not till d goal reached

  2. #2
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: VBA to copy multiple Text boxes values to a sheet

    Hello sagar007
    I have done some work on this requirement as follows:
    1. implemented the "Register New Product" functionality
    2. implemented the "GRIR" functionality
    The "Delivery_Challan" functionality that you require is the essentially same as the GRIR functionality.
    There is therefore enough information for you to to implement this part yourself and take your own knowledge/learning forward.
    Please note that I have re-named some text boxes in the GRIR userform and I have also had to implement <Submit> and <Exit> buttons on this form.
    From this point of view it is not for me to start redesigning parts of your model especially since it is already very elaborate and I do not fully understand your workflows.
    Over to you.

    Inventory v3.xlsm
    If this was helpful then please click the small star icon at the bottom left of my post. A little appreciation goes a long way.

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: VBA to copy multiple Text boxes values to a sheet

    Hey Brother

    Awesome, perfect

    Everything is working like a charm which i wanted, Thank you so much

    No Word to say anything, god bless you.

    Again Thank you very very much

    Reputation Added .

    Sagar


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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