+ Reply to Thread
Results 1 to 3 of 3

Transfer User form data to a worksheet w.r.t. combobox item on the form

  1. #1
    Registered User
    Join Date
    01-29-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Transfer User form data to a worksheet w.r.t. combobox item on the form

    Dear Sir and all my friends,
    I have a problem of transfering data from a user form to a predefined worksheet whrere the data should get stored serially as per the items selected from the combobox on the user form. I am very new to excel and do not know much about excel vb programming. I have 65 items listed in the combobox and it is the 1st control to be selected on the user form while feeding data. Secondly I need to start with the 4th row in the worksheet to store the data for 1st item in the combo list. It should be such that the 1st item data on the user form will get stored in 4th row, the 2nd item in the 5th row and so on till 65th item. And the rows should be fixed for these items. Means when I feed the data for 1st item it should go to 1st row only. If a sample example(showing four to five data input text boxes with combo box list of 65 items (items like AS001,AS002 AB210....not fixed serially but limited to 65 items) data input with code can be replied, It will be of immense help to me.

    Secondly, I want to have a time data to be displayed back on the user form in the same format as displayed in the worksheet. I have three text boxes on the user form that give the input to the predefined worksheet the time value. These are calculated in the sheet and stored in a cell that displays the required time data. That data I want to display back while saving the userform input to the worksheet. Example : On the User form X, Text Box 1, 2, and 3 are fed with time (as text) like 456:25, 25:00, 564:33 etc respectively and even sometimes 00:00. When transfered to worksheet Y, they are conditionally calculated and the result is stored in Cell say F2 for first row data. I have a text box on the user form to display thedata stored in F2 in the same format. The time format of the cell F2 is (37:30:55 pattern) I have tried and the data is getting displayed but in a format like 23.4444444 or when I change the value showing 15.33333333444 etc. So how can it be displayed in the same format as in the F2 cell. Note that Full F2 column will be holding the result when I feed the other rows.

    Thanking you


    Regards,

    nm766
    Attached Files Attached Files
    Last edited by nm766; 01-31-2011 at 02:02 PM. Reason: Submitting Sample for clarification

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Transfer User form data to a worksheet w.r.t. combobox item on the form

    Hi nm766

    If a sample example(showing four to five data input text boxes with combo box list of 65 items (items like AS001,AS002 AB210....not fixed serially but limited to 65 items) data input with code can be replied
    A sample of what you have, with the UserForm and the code behind it, will be very helpful. Please include an "after" worksheet in your sample.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    01-29-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to copy selected range of columns to another work sheet

    Dear friends,

    I am having problem of transfering few data columns of a work sheet to another in the same work book. Problem is few columnsae haning calculation formulas. For ex:= If I require to transfer the cell values of A2 to F67and againN2 to Q67 and againR2 to R67,of Work Sheet 'A' to WorkSheet 'B' How the code be written. I do not want to manually copy and Paste special the required range of cells. It shoule run automatically.

    hanks

+ 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