+ Reply to Thread
Results 1 to 8 of 8

How to create user form under VBA for entering data

  1. #1
    Forum Contributor
    Join Date
    11-24-2019
    Location
    India
    MS-Off Ver
    Ms. Office 2016
    Posts
    169

    How to create user form under VBA for entering data

    Hello friends,
    I want to enter data in sheet 1 using user form having based of VBA coding. My requirement is that,

    1. I want button on sheet 1 by the name 'Enter Data'. When i click on that button user form will be open up.

    2. I have table in sheet 1 in which i want to enter data. Fields in the table are [a] Sr. No. [b] Date [c] Name of the Category [d] Items under Category [e] Quantity.

    3. Important thing is that, menu of '[d] items under category' is dependent to '[c] Name of the Category'.

    I have following three categories in my shop: Fruits, Vegetables and Dry Fruits.
    Under each of the category following items are includes:
    Fruits: Apple, Orange, papaya, grapes and Kivi.
    Vegetables: Ladyfinger, coli-flower, cabbage and eggplant
    Dry fruits: Almonds, cashews, walnuts, pistachio and dates.

    Under this i want dependent list. Means if i click on Fruits, in the next cell list of fruits should be auto-populated so that i can select one them. If i select vegetables then in the next cell list of vegetables should be auto-populated so that i can select one of them, and so on in case of Dry fruits. But if i go to previous cell of '[c] Name of the Category' then next cell should be automatically changed its options as per previous cell on which it is dependent.

    4. Data entry in sheet 1 is expected to be start from
    cell A4 for [a] Sr. No., Cell B4 for [b] Date, C4 for [c] Name of the Category, Cell D4 for [d] Items under Category, E4 for [e] Quantity.
    If possible Sr. no. should be auto-populated.

    5. Date should in the format dd-mm-yyyy

    6. I also need following functions / buttons / options on user from: Add Data, Search Data, Edit Data, Delete Data.

    6. If possible under Search Data options, search can be done by various criteria as per [a] Sr. No. [b] Date [c] Name of the Category [d] Items under Category [e] Quantity.

    7. Some times Quantity remains in decimal form e.g. 11, 12.50 which should not be changed. Means 12.50 should be 12.50 and not 12.5

    I have also attached file for understanding of table.

    Thank you for your help in advance. This will be your great help.

    Message also posted for responses:
    https://www.mrexcel.com/board/thread...-data.1146126/
    https://www.excelguru.ca/forums/show...-entering-data
    Attached Files Attached Files
    Last edited by chintamani.avinash; 09-24-2020 at 02:03 PM.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to create user form under VBA for entering data

    simply based on the fact that you said this:
    Quote Originally Posted by chintamani.avinash View Post
    Hello friends,
    I want to enter data in sheet 1 using user form having based of VBA coding..
    you may want to see the example I posted for someone else:

    https://www.excelforum.com/excel-gen...ml#post5395642

  3. #3
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: How to create user form under VBA for entering data

    Hi chintamani,

    Try the attached file

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  4. #4
    Forum Contributor
    Join Date
    11-24-2019
    Location
    India
    MS-Off Ver
    Ms. Office 2016
    Posts
    169

    Re: How to create user form under VBA for entering data

    Quote Originally Posted by nankw83 View Post
    Hi chintamani,

    Try the attached file

    Please Login or Register  to view this content.
    Thanka alot for your reply. Your code works good. But i also want some functionality / buttons to forms. These buttons and their functions are:

    Add Data: Data will be added to specific cells but after adding data forms should not be closed. It should be open for next entry.
    Close: Close button will close the form.
    Search: Find something based on criteria of date, name of the category, items under category, quantity.
    Delete Data: This will delete complete row of that data.
    Edit Data: To edit data searched via search button.

    Also in the form i am in need of Serial No and date field. Serial if possible should be auto-populated and date should be dd/mm/yyyy form.

    Thanks for your support

  5. #5
    Forum Contributor
    Join Date
    11-24-2019
    Location
    India
    MS-Off Ver
    Ms. Office 2016
    Posts
    169

    Re: How to create user form under VBA for entering data

    Quote Originally Posted by vba_php View Post
    simply based on the fact that you said this:
    you may want to see the example I posted for someone else:

    https://www.excelforum.com/excel-gen...ml#post5395642
    Thanks for reply. Trying to learn from it but find lil difficult.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: How to create user form under VBA for entering data

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  7. #7
    Forum Contributor
    Join Date
    11-24-2019
    Location
    India
    MS-Off Ver
    Ms. Office 2016
    Posts
    169

    Re: How to create user form under VBA for entering data

    Quote Originally Posted by alansidman View Post
    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    What is cross post link? how it should be posted?

  8. #8
    Forum Contributor
    Join Date
    11-24-2019
    Location
    India
    MS-Off Ver
    Ms. Office 2016
    Posts
    169

    Re: How to create user form under VBA for entering data

    Quote Originally Posted by chintamani.avinash View Post
    What is cross post link? how it should be posted?
    link shared, but still waiting for my Q's answer

+ 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. [SOLVED] Define where to start entering data from a user form
    By chloedee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2015, 08:16 AM
  2. Entering image in to a worksheet from user form
    By Citrix1966 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2014, 07:37 AM
  3. How to write a VBA with User form for Entering the DATA to print a cheque
    By vajeednawab in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2013, 04:37 PM
  4. Custom Design Data Entry User Form for Entering Customer Information
    By dizzle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2013, 01:37 PM
  5. Calling a user form initialize sub when entering the form to populate combobox...
    By regupnorth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2012, 07:24 AM
  6. Entering worksheet data via user form
    By Tellus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2008, 01:37 PM
  7. [SOLVED] How to create a vba Form for entering data into Spreadsheet ?
    By tmb in forum Excel General
    Replies: 2
    Last Post: 03-29-2005, 05:06 AM

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