+ 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: Office 365 in Windows environment
    Posts
    8,606

    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: Office 365 in Windows environment
    Posts
    8,606

    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)

Similar Threads

  1. [SOLVED] VBA Modify cell values in a range
    By domz3669 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-13-2018, 06:38 PM
  2. [SOLVED] Filling 2 seperate listboxes with different values based on combobox choices
    By bbqqsmokeman in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-26-2017, 02:34 PM
  3. How to Loop through Column and Modify Values Based on User Input
    By bryanmarks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2015, 11:38 AM
  4. Excel 2003 formula - modify one cell, another cell track the modify date
    By baby0596cw in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-06-2014, 12:55 PM
  5. Modify Cell Background Color based on cell content
    By CWDurkin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2014, 11:57 AM
  6. VBA modify value based on conditions of another cell
    By sk8shorty01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-26-2011, 01:20 PM
  7. Populating Two Listboxes with Sheets Based on Cell Value & Printing Their Selection
    By TBrooker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2009, 03:45 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