Results 1 to 2 of 2

Thread: Creating a personalized "data" form (VBA/Macros) - To add, retrieve, modify & delete

  1. #1

    Creating a personalized "data" form (VBA/Macros) - To add, retrieve, modify & delete



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I find it very easy to create forms that allow you to enter information. Creating a form that generates reports or a form that retrieves "profiles" or information is another story...

    I want a main form that is always opened (I've seen the codes for this before, not a major issue) and I want it to act as a main interface.

    As a lot of information will be added and modified constantly, I simply want users to also be able to use the form to retrieve our "clients profiles" (a profile = a row of information). Perhaps I could have a "search" button, as well as a "Enter New info", or "modify"...

    The last thing, generating reports, would not be part of the main form. Other buttons placed on the first sheet would generate reports in the second sheet (or third if the second is used as a database?) allowing users to print or save those reports for zillion purposes. Should I be using conditional formatting in macros? This is where my knowledge goes a FVKQ#)$.


    perhaps somebody out there could help me?

    Many thanks,
    AdR

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Are you referring to a UserForm or a Worksheet designed as a form?
    Hope that helps

    Roy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •