+ Reply to Thread
Results 1 to 18 of 18

Data Entry form help!

  1. #1
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Data Entry form help!

    Dear Experts,

    I would like to convert direct cell entry to form entry.
    Im new to VBA coding, I have created entry form with all required fields, Please help me on further action.

    Attached for your reference

    Thank you so much for your time on this.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    You're trying to add the information from the userform onto the appropriate worksheets month correct? Not the SampleData-Apr worksheet?

    Thanks!

  3. #3
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Re: Data Entry form help!

    Yes, SampleData-Apr - Sheet is just a sample data, it has data validation(list type) option, to explain where the list is coming from. Thanks !!!

  4. #4
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    No problem working on it now

  5. #5
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    I have it completed just one last questions. What did you want the edit button on the form to do?

    Attached is your workbook updated to perform your requests. The Edit button does not perform an action yet as I was unsure as to what exactly you wanted it to do.

    Thanks!
    Attached Files Attached Files
    Last edited by rvasquez; 05-31-2012 at 04:13 PM.

  6. #6
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Re: Data Entry form help!

    Thank You for your effort
    Form is in action now and performs what exactly I requested. I like that popup box "Input Petty Cash". Thanks a lot

    1.Edit Button : I thought of editing the previous submitted data. Is it Possible? by clicking the date(submitted data), the form opens with its related data and then edit them and Update - button (instead of Submit). I realized that in this case Edit button is nothing to do

    2.Can u please help me on Validating.
    Required field : Month, Date, Mode,Expense Ledger, Description and Gross Value
    Criteria 1 : IF Tax Rate(Y) has any value then user must enter Seller Name
    Criteria 2 : IF Input Petty Cash enabled then Expense Ledger have to be disabled

    Thank you for your help once again

    Cheers!!!
    SK
    Last edited by skhari; 05-31-2012 at 11:52 PM.

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Data Entry form help!

    You should declare your variables properly. In this case LRA should be a Long,as it is now Excel will interpret it as a Variant.

    You don't need to select the sheets to write to them.

    Note also the correct use of the With Statement, the original code uses with ActiveSheet but does not use the . before the range so the code is only posting to the correct sheet because the sheet has been slected.

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  8. #8
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    Hello there,

    Attached is the updated workbook, give it a whirl and let me know what you think.

    Also, I'm still not quite sure what you are trying to do with the edit button. Below are a list of options that I can think of:

    1. Are you trying to select a row and have its information populate on the userform
    2. Are you wanting a listbox on the userform where the person can select a record and then click alter to pull in the information and change it
    3. Are you wanted to enter certain data and search for that record and the populate the information on the userform.

    Let me know!

    Thanks!
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Re: Data Entry form help!

    Hi rvasquez

    The updated workbook was perfect. thanks

    Reg Editing. Yes, 2nd point is best option. Thats what im thinking to have it. Can we have tab(says Editing) on top left of the user form which displays record of the particular month and then click alter to pull in the information and change it (update it) - If Possible and if Simple

    Thanks for supporting.
    Last edited by skhari; 06-01-2012 at 01:32 PM.

  10. #10
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    Hey there,

    Just got to work this morning and will begin working on this, sorry about the delay.

  11. #11
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    Alrighty,

    Try this and let me know what you think.

    Thanks!

    Rvasquez
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Re: Data Entry form help!

    thank you so much. that is very kind of you.

    Seller Tin Number is not displaying what should i do (editing particular record).

    Also if you have time. Please look at this query and let me know your suggestion
    http://www.excelforum.com/excel-prog...20#post2811020

    Thanks

    sk

  13. #13
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    Sorry, but what do you mean it is not displaying what it should? When you pull in the information or when you paste it? When you select a seller name?

    Right now it is set up to automatically populate the seller tax number that is next to the seller name in the seller details worksheet.

    Took a look at your other post. Add some comments.
    Last edited by rvasquez; 06-04-2012 at 10:46 AM.

  14. #14
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Re: Data Entry form help!

    When i pull the information, Seller tax number is not populating

  15. #15
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    Okay right adjust the code as follows:

    Open VBA by pressing Alt+F11. Double click on the UserForm1 in the Project Window. This will bring up the userform. Select the Record tab and then right click on the Edit button. Select the View code option.

    Scroll through the code until you see the line of text

    Please Login or Register  to view this content.
    Replace this line of text with the following:

    Please Login or Register  to view this content.
    Be careful not to delete any of the surrounding code.

    Select the userform1 from the project window again. Select the first tab "Input Information" then exit out of Visual Basic. Save the workbook and then try to use the form again.

  16. #16
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Re: Data Entry form help!

    thats working.!!!

  17. #17
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Data Entry form help!

    Great! If this post is solved please mark it as such and if I have helped you, if you could kindly give me a star tap that would be awesome!

    Thanks!

  18. #18
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Re: Data Entry form help!

    Hi rvasquez

    Back to the solved one. one small query. While editing (clicking the Record tab) last submitted data is not populating. It happens only when i change MonthCB, I have to again reselect the month and then i can see the last submitted data. Please have a check.
    thank you

+ 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