Rabu, 27 Mei 2015

Re: [ExcelVBA] Enter text in a cell, but retain original value


HI Paul... Do you want/need a file uploaded for the group??

Lisa ( Group Moderator )

Sent: Wed, May 27, 2015 6:44 pm
Subject: Re: [ExcelVBA] Enter text in a cell, but retain original value

This is a portion of the workbook I use to keep track of my vacation  schedule. If you change the year in cell B1, it will create a new  worksheet.selecting a cell (or group of cells) and clicking one of the  "Scheduled" or "Used" buttons will modify the selected cells to append a  letter.the totals on the left keep track of scheduled and used vacation days  (half and full days only) to remove the flag, select the cell and hit the  "clear" button. Since the clear macro utilizes adjacent cells to determine the  correct replacement cell value, sometimes the cells don't reset properly. For  instance, if you've scheduled the last two weeks of the month as vacation, then  choose to reset the last week, all adjacent cells are not valid dates, so it may  not reset. (I instead clear the first week, then the second, then reschedule the  first) It's worked fine for me since 2008  !!! Paul-----------------------------------------  "Do all the good you can,  By  all the means you can,  In all the ways you can,  In all the places you can,  At  all the times you can,  To all the people you can,  As long as ever you can." -  John Wesley  -----------------------------------------           From:  "Courtneygunn@aol.com [ExcelVBA]" <ExcelVBA@yahoogroups.com>   To:  ExcelVBA@yahoogroups.com    Sent: Wednesday, May 27, 2015 9:41 AM   Subject: Re:  [ExcelVBA] Enter text in a cell, but retain original value           Hi  Paul,    Any chance in sharing with the rest of the community - to learn from?         Courtney      "Wise men speak because they have something to say; Fools  because they have to say something." - Plato          


Posted by: Green <1z@compuserve.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar