Rabu, 27 Mei 2015

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


-----Original Message-----
From: Duncan Edment duncan.edment@gmail.com [ExcelVBA] <ExcelVBA@yahoogroups.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Wed, 27 May 2015 14:36
Subject: Re: [ExcelVBA] Enter text in a cell, but retain original value

  Paul, that would be great.  Sounds just like what I need. Duncan
#yiv1938086898 #yiv1938086898 -- #yiv1938086898ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1938086898 #yiv1938086898ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1938086898 #yiv1938086898ygrp-mkp #yiv1938086898hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1938086898 #yiv1938086898ygrp-mkp #yiv1938086898ads {margin-bottom:10px;}#yiv1938086898 #yiv1938086898ygrp-mkp .yiv1938086898ad {padding:0 0;}#yiv1938086898 #yiv1938086898ygrp-mkp .yiv1938086898ad p {margin:0;}#yiv1938086898 #yiv1938086898ygrp-mkp .yiv1938086898ad a {color:#0000ff;text-decoration:none;}#yiv1938086898 #yiv1938086898ygrp-sponsor #yiv1938086898ygrp-lc {font-family:Arial;}#yiv1938086898 #yiv1938086898ygrp-sponsor #yiv1938086898ygrp-lc #yiv1938086898hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1938086898 #yiv1938086898ygrp-sponsor #yiv1938086898ygrp-lc .yiv1938086898ad {margin-bottom:10px;padding:0 0;}#yiv1938086898 #yiv1938086898actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1938086898 #yiv1938086898activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1938086898 #yiv1938086898activity span {font-weight:700;}#yiv1938086898 #yiv1938086898activity span:first-child {text-transform:uppercase;}#yiv1938086898 #yiv1938086898activity span a {color:#5085b6;text-decoration:none;}#yiv1938086898 #yiv1938086898activity span span {color:#ff7900;}#yiv1938086898 #yiv1938086898activity span .yiv1938086898underline {text-decoration:underline;}#yiv1938086898 .yiv1938086898attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1938086898 .yiv1938086898attach div a {text-decoration:none;}#yiv1938086898 .yiv1938086898attach img {border:none;padding-right:5px;}#yiv1938086898 .yiv1938086898attach label {display:block;margin-bottom:5px;}#yiv1938086898 .yiv1938086898attach label a {text-decoration:none;}#yiv1938086898 blockquote {margin:0 0 0 4px;}#yiv1938086898 .yiv1938086898bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1938086898 .yiv1938086898bold a {text-decoration:none;}#yiv1938086898 dd.yiv1938086898last p a {font-family:Verdana;font-weight:700;}#yiv1938086898 dd.yiv1938086898last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1938086898 dd.yiv1938086898last p span.yiv1938086898yshortcuts {margin-right:0;}#yiv1938086898 div.yiv1938086898attach-table div div a {text-decoration:none;}#yiv1938086898 div.yiv1938086898attach-table {width:400px;}#yiv1938086898 div.yiv1938086898file-title a, #yiv1938086898 div.yiv1938086898file-title a:active, #yiv1938086898 div.yiv1938086898file-title a:hover, #yiv1938086898 div.yiv1938086898file-title a:visited {text-decoration:none;}#yiv1938086898 div.yiv1938086898photo-title a, #yiv1938086898 div.yiv1938086898photo-title a:active, #yiv1938086898 div.yiv1938086898photo-title a:hover, #yiv1938086898 div.yiv1938086898photo-title a:visited {text-decoration:none;}#yiv1938086898 div#yiv1938086898ygrp-mlmsg #yiv1938086898ygrp-msg p a span.yiv1938086898yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1938086898 .yiv1938086898green {color:#628c2a;}#yiv1938086898 .yiv1938086898MsoNormal {margin:0 0 0 0;}#yiv1938086898 o {font-size:0;}#yiv1938086898 #yiv1938086898photos div {float:left;width:72px;}#yiv1938086898 #yiv1938086898photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1938086898 #yiv1938086898photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1938086898 #yiv1938086898reco-category {font-size:77%;}#yiv1938086898 #yiv1938086898reco-desc {font-size:77%;}#yiv1938086898 .yiv1938086898replbq {margin:4px;}#yiv1938086898 #yiv1938086898ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1938086898 #yiv1938086898ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1938086898 #yiv1938086898ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1938086898 #yiv1938086898ygrp-mlmsg select, #yiv1938086898 input, #yiv1938086898 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1938086898 #yiv1938086898ygrp-mlmsg pre, #yiv1938086898 code {font:115% monospace;}#yiv1938086898 #yiv1938086898ygrp-mlmsg * {line-height:1.22em;}#yiv1938086898 #yiv1938086898ygrp-mlmsg #yiv1938086898logo {padding-bottom:10px;}#yiv1938086898 #yiv1938086898ygrp-msg p a {font-family:Verdana;}#yiv1938086898 #yiv1938086898ygrp-msg p#yiv1938086898attach-count span {color:#1E66AE;font-weight:700;}#yiv1938086898 #yiv1938086898ygrp-reco #yiv1938086898reco-head {color:#ff7900;font-weight:700;}#yiv1938086898 #yiv1938086898ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1938086898 #yiv1938086898ygrp-sponsor #yiv1938086898ov li a {font-size:130%;text-decoration:none;}#yiv1938086898 #yiv1938086898ygrp-sponsor #yiv1938086898ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1938086898 #yiv1938086898ygrp-sponsor #yiv1938086898ov ul {margin:0;padding:0 0 0 8px;}#yiv1938086898 #yiv1938086898ygrp-text {font-family:Georgia;}#yiv1938086898 #yiv1938086898ygrp-text p {margin:0 0 1em 0;}#yiv1938086898 #yiv1938086898ygrp-text tt {font-size:120%;}#yiv1938086898 #yiv1938086898ygrp-vital ul li:last-child {border-right:none !important;}#yiv1938086898

[Non-text portions of this message have been removed]

__._,_.___

Posted by: Paul Schreiner <schreiner_paul@att.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
----------------------------------
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:

Poskan Komentar