HI Paul... Do you want/need a file uploaded for the group??
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:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar