Consulting

Results 1 to 6 of 6

Thread: User form Help

  1. #1

    User form Help

    Attaching 2 files here
    User form file has a form with several fields.
    Grey column should update values in User form
    Pink column should update values in Sheet.

    I want to start User form as soon as user click on Audit Done column.
    So if user click on Audit done in Row 2, User form should react with Row 2 data and so on.
    Attached Files Attached Files

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,064
    Location
    What populates the cells of the active row O to AD
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    When I click on col M let's say M2.
    User form should open and autofills Row 2 data like.
    Emp Name
    CITRIX I'd
    Team Manager
    Avaya I'd
    Skill
    Language
    Score
    Call date
    Call time
    Account Number.

  4. #4
    Quote Originally Posted by Aussiebear View Post
    What populates the cells of the active row O to AD
    Kindly refer to event sheet. It has events, dsat drivers..

  5. #5
    I used userfoem.initialize and was able to get it working.
    Have issue with combo box conditions based on selection

  6. #6
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    You will have issues if you don't write any code.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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