+ Reply to Thread
Results 1 to 5 of 5

adapting code for two multipages on userform & copy into one sheet

  1. #1
    Forum Contributor
    Join Date
    05-25-2022
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    225

    adapting code for two multipages on userform & copy into one sheet

    Hi
    I got this code from this forum and this code for Jindon
    Please Login or Register  to view this content.
    I can't deal with this code . I no know if anybody has idea to modifying or create new code . so I have multiple textboxes & comboboxes when run the userform should show for each row in userfrom when select combobox (BATCH) should show all of the items and values the comboboxes(BATCH & PR.NO,TTY.TT,MM.NN)= column B,C,D,E) and the textboxes QTY,PRICE = columns F,G . about textbox (TOTAL) should depends on textbx(qty)* textbox(price) and shows the formatting of numbers and currency as in sheet PRICE ,but not depends on column H in sheet PRICE because I will change the value for textbox(QTY) and when I fill all of textboxes and comboboxes in page1,page2 should copy to sheet DATA from row 6 .
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-25-2022
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    225

    Re: adapting code for two multipages on userform & copy into one sheet

    can any body see my request,please?

  3. #3
    Forum Contributor
    Join Date
    05-25-2022
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    225

    Re: adapting code for two multipages on userform & copy into one sheet

    where is the help experts ?

  4. #4
    Forum Contributor
    Join Date
    05-25-2022
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    225

    Re: adapting code for two multipages on userform & copy into one sheet

    I try adusting some lines to first request by making four comboboxes instead three comboboxes from
    Please Login or Register  to view this content.

    to
    Please Login or Register  to view this content.
    it gives object required in this line
    Please Login or Register  to view this content.

    and from this
    Please Login or Register  to view this content.
    to this
    Please Login or Register  to view this content.
    it seems extremely complicated , nobody answers me so far despite of asking the help for many times.

  5. #5
    Forum Contributor
    Join Date
    05-25-2022
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    225

    Re: adapting code for two multipages on userform & copy into one sheet

    guiding experts

+ 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. Replies: 4
    Last Post: 01-26-2022, 03:33 AM
  2. [SOLVED] Required vba code copy data sheets to new workbook & retn to old sheet userform
    By sbvaram in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2020, 12:55 AM
  3. [SOLVED] amend code copy data from userform to sheet before lastrow
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-14-2020, 01:05 PM
  4. adapting a downloaded, excel date picker form into my own userform
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2014, 03:50 PM
  5. Printing Userform - Multipages double sided or on one page
    By rruiter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2013, 03:46 AM
  6. Dynamically Adding Multipages to Multipages
    By jwidhalm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2005, 04:23 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