+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7
Results 91 to 99 of 99

Insert Dropdown List inside Calendar Days

  1. #91
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,991

    Re: Insert Dropdown List inside Calendar Days

    what code?
    You don't run any code, just change the font color of the task and make it bold or not and then go back to the calendar and add that task
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you ( It doesn't hurt )

  2. #92
    Forum Contributor 323100N's Avatar
    Join Date
    08-11-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    270

    Re: Insert Dropdown List inside Calendar Days

    Yup, and I compare the new code inside the Add selection item radio button and there is an additional code, Is that a code to capture the TASKLIST format in RefSheet?

  3. #93
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,991

    Re: Insert Dropdown List inside Calendar Days

    Yes, I added a column to the Listbox but the column is hidden, in that item I keep the corresponding row number for that task so that I can use it to read the tasks properties like bold, and color

    Like I mentioned the highlight will be removed if you only add a new task to an existing list, that code needs to be (re)written and will require more time and imagination

  4. #94
    Forum Contributor 323100N's Avatar
    Join Date
    08-11-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    270

    Re: Insert Dropdown List inside Calendar Days

    Yeah no worries and again thank you for your time looking into this and for helping.

  5. #95
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,991

    Re: Insert Dropdown List inside Calendar Days

    I'm sure there are other ways to approach this but this the way I would do it.
    I'll do some testing and see if I can come up with some code to also allow adding a task and keeping the original formatting, this will however imply that the order of the tasks will result in the same alphabetical order as it is in the RefSheet.
    I'll also see if I can manage the deleting of one task which at this moment doesn't really work as it should.
    VBA is all about playing around with conditions, write it down in words and then 'translate' it into (vba)code, that's really the basic idea

  6. #96
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,991

    Re: Insert Dropdown List inside Calendar Days

    Hi, I think I got it all working now, the Task Lists will be formatted according to the setting you have decided in the RefSheet.
    Unhide and read the textbox 'My Solution'
    In the Userform VBA I removed the Highlight routine since it's no longer necessary but dit leave the Radio Button to 'Refresh Cell Content'
    Let's say you decide to change the Tasklist format in the RefSheet then all you need to do is select the cell in the monthly sheet open the form and click the reset radio button to update the cell content, of course this Radio Button is only visible when the cell has content
    Enjoy the file
    Attached Files Attached Files

  7. #97
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,991

    Re: Insert Dropdown List inside Calendar Days

    I noticed that some message boxes were incorrect with the OK / Cancel buttons
    Corrected and have attached updated file (v3.4)
    Attached Files Attached Files

  8. #98
    Forum Contributor 323100N's Avatar
    Join Date
    08-11-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    270

    Re: Insert Dropdown List inside Calendar Days

    Hi Keebellah,

    I hope everything is well with you. I already saw the updated version and its fantastic and working really well. Thank you again for helping and taking your time with this.

    Have a great day.

  9. #99
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,991

    Re: Insert Dropdown List inside Calendar Days

    Hi, all's well here.
    Glad to have been able to make it work, I learned 'new tricks' on the way too
    You know where to find me
    Have a great day too.

+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7

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