+ Reply to Thread
Results 1 to 4 of 4

Modify cell values based on listBoxes

  1. #1
    Registered User
    Join Date
    01-24-2020
    Location
    Morocco
    MS-Off Ver
    2016
    Posts
    6

    Modify cell values based on listBoxes

    Hi everyone,

    So i want to initialise the values of some cells based on a selection from a listbox containing the projects and a listbox containing the weeks

    I want the user to select a project that he is working on and then the week number (S1,S2,S3,S4) in which he wants to enter his productivity (or the time he has put in effort to work on that specific project),

    With those two selections from listboxes i want to update the values of the cells presents in the worksheet,

    Here is the code i have written so far but i have a "Run time error '424' : object required"


    Please Login or Register  to view this content.
    Here is an example of the workboook :
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,002

    Re: Modify cell values based on listBoxes

    You have changed the name of the UsewForm from default UserForm1 to Productivity_Tracker
    So there is no such object as UserForm1
    Change the code to:
    Please Login or Register  to view this content.
    and so on.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    01-24-2020
    Location
    Morocco
    MS-Off Ver
    2016
    Posts
    6

    Re: Modify cell values based on listBoxes

    Thanks man

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,002

    Re: Modify cell values based on listBoxes

    You are welcome,

    Would be a good idea to mark thread as Solved.
    Above your first post you will find Thread Tools to do it.

    It would be lovely if you could also "add me some reputation" by clicking a small star icon in lowerleft corner of my post and then confirm in pop-up message (note that some browsers block this pop-up).

+ 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