+ Reply to Thread
Page 2 of 15 FirstFirst 1 2 3 4 12 ... LastLast
Results 16 to 30 of 225

Adding additional goals and objectives in a treatment plan using a form control button

  1. #16
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    Thanks. Will be home in an hour and a half and will re-post then.

  2. #17
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    John,

    Here you go. Hope this works. I just noticed that when messing with this version of the form the drop down lists copied and pasted with the next line, at least I think they did. Let's see if it does it for you. Thanks.

    HCT ITP (2-28-14) Mock Treatment Plan v3.xlsm

  3. #18
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,643

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    Hi Matthew

    I still see no Dropdowns (Data Validation) in your most recent attachment. However, if you put them in, they'll be copied.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #19
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    John,

    Wow, I'm so confused about the lack of drop downs when you open it. I've attached a screen shot from the file when I open it and click on the cell next to "from" or "to".

    drop down.jpg


    While I figure out what's happening with that here's another glitch I've run into. When Button 15 is clicked and the specified STG is deleted the STG # does not recalculate which results in the plan having STG 1, STG 2, STG 4...instead of STG 1, STG 2, STG 3. I'll run into this when I begin work on the "Add Obj." and "Delete Obj." buttons so if you could specify the line of code that you adjust here I'll try my hand at it with the other buttons. Thanks.

    Matthew
    Last edited by moosetales; 03-03-2014 at 09:42 AM.

  5. #20
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,643

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    Hi Matthew

    Regarding this
    When Button 15 is clicked and the specified STG is deleted the STG # does not recalculate
    Replace your Button 15 Code with this
    Please Login or Register  to view this content.

  6. #21
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    John,

    The new code for Button 15 worked perfectly (see below).

    HCT ITP (2-28-14) Mock Treatment Plan v4.xlsm

    My next issues is finding a way for the "Add Obj" and "Delete Obj" buttons to copy and paste when the button 10 ("Add STG") is clicked.

    Thanks.

  7. #22
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,643

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    Hi Matthew

    If you need help figuring that out, let me know. Gotta tell you, don't know what this means
    finding a way for the "Add Obj" and "Delete Obj" buttons to copy and paste when the button 10 ("Add STG") is clicked.
    You'll need to show me...

  8. #23
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    John,

    I hope to get better as I go at communicating what I need. Thanks for your patience. Here are two screen shots of what I'm talking about.

    This is a screen shot of what the form looks like now. It has three STGs added. On the far right of the form, just under the "from" and "to" cells are two buttons; "Add Obj" and "Delete Obj". These buttons need to be duplicated each time a new STG is added.

    Current view (buttons not added).jpg

    Here's a screen shot of what I'm hoping for.

    Buttons Added.jpg

    The "Add Obj" and "Delete Obj" buttons will allow me to add or delete new Obj under each STG.

    Thanks.

  9. #24
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,643

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    Hi Matthew

    The communication issue is mostly me...I'm a Tactile/Kinesthetic learner...I learn by "seeing" and "doing".

    Place in your Form the Objective Added just as if you Clicked the Add Obj Button...this is what I mean by "show me".

  10. #25
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    John,

    Here's a screen shot of what I'm hoping to accomplish as well as an updated version of the form with the Obj added.

    Objs Added.jpg

    HCT ITP (2-28-14) Mock Treatment Plan v5.xlsm

    Thanks.

  11. #26
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,643

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    Hi Matthew

    Adding the additional Objectives blows the Code for Command Buttons 10 and 15 out of the water. I'll need to look at it...

  12. #27
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    John,

    If I'm understanding you correctly, to do what I'm wanting would require the current Code for Command Buttons 10 and 15 to be TOTALLY reconfigured? If so, let me take a look and see if there is an alternative that would involve less effort. I value your input and am sensitive to the fact this is a forum to address relatively small coding and other related issues. Thanks.

    Matthew

  13. #28
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,643

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    Hi Matthew

    I think I have the Command Button 10, 15 issue sorted...not to worry. I'm currently tied in knots in getting your Add Obj, Delete Obj Buttons added in the CORRECT place...this is important as any Code will be driven based on their location.

    I'll attach a File with the modified Code. The File will include a Named Range called mySTG located (for the moment) in
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  14. #29
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    Quote Originally Posted by jaslake View Post
    Hi Matthew

    I think I have the Command Button 10, 15 issue sorted...not to worry. I'm currently tied in knots in getting your Add Obj, Delete Obj Buttons added in the CORRECT place...this is important as any Code will be driven based on their location.

    I'll attach a File with the modified Code. The File will include a Named Range called mySTG located (for the moment) in
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    John,

    I could not get the v5.2 to open and function as expected. It kept attempting to reference code in an earlier version of my form and had a STG 2 off to the right of the screen. I think I've found a fairly straight forward workaround...see next post.

  15. #30
    Forum Contributor
    Join Date
    02-22-2014
    Location
    Winthrop, ME
    MS-Off Ver
    Excel 2010
    Posts
    420

    Re: Adding additional goals and objectives in a treatment plan using a form control button

    John,

    Concept #1


    My thought in regards to the Button 11 and Button 16 is to treat them just like Button 10 and Button 15; all four buttons would be in a row and would drop down together each time lines were added above them. (see image below) Button 11 would have an Input Box where the following message would pop up when Button 11 was clicked, "Please Click on Column D "Please Click on Column D Of The Obj to be Added." or something like that. I attempted in the attached version (v7) of my form to code Button 11 to add a new Obj but no cigar.

    add obj concept.jpg

    Concept #2


    Remove Button 11 and Button 16 altogether and just have Button 10 coded to copy and paste 4 Obj each time a new STG is added. This is the less preferred method at this time. I have coded Button 10 in the attached version of my form (v7) to copy and paste 4 Obj with each new STG.

    Let me know what you think of if I've confused the heck out of you. Thanks.

+ Reply to Thread
Page 2 of 15 FirstFirst 1 2 3 4 12 ... LastLast

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