Results 1 to 10 of 12

Thread: User Form entry in a second sheet - need help with VBA code

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Feb 2022
    Posts
    11
    Rep Power
    0

    User Form entry in a second sheet - need help with VBA code

    Hi all,

    I'm trying to use a form to add data to 2 sheets (Database and Database1).
    In the first sheet (Database) each entry is added as a new line and everything is working fine.
    The problem is when I try to add the data in the second sheet because I have to to match 3 criteria (name, project and task) and I don't know how to write the exact code for that.
    I have used a code from a previous version of that form where only 2 criteria were matched (name and project).
    In the Database1 sheet I filled with colors the cells where the values from the Database sheet must be entered.
    I am attaching the work file.
    Thanks in advance! Any help would be appreciated!

    I have posted the same thread here
    https://www.mrexcel.com/board/thread...-code.1196175/




    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Files Attached Files
    Last edited by DocAElstein; 10-02-2023 at 12:44 PM.

Similar Threads

  1. Inserting Image In VBA User Form Caption
    By littleiitin in forum Download Center
    Replies: 3
    Last Post: 02-22-2021, 03:07 PM
  2. create invoice with user form
    By anil21 in forum Excel Help
    Replies: 7
    Last Post: 02-07-2018, 04:57 PM
  3. VBA Code for User Form
    By dkesar in forum Excel Help
    Replies: 1
    Last Post: 01-02-2015, 03:19 PM
  4. Replies: 5
    Last Post: 06-13-2014, 08:37 PM
  5. Replies: 7
    Last Post: 03-11-2014, 05:38 PM

Posting Permissions

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