Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 09-05-2013, 12:33 PM
David Geren David Geren is offline Display a label character in a data cell Windows 7 32bit Display a label character in a data cell Office 2010 32bit
Novice
 
Join Date: Sep 2013
Posts: 2
David Geren is on a distinguished road
Default

Thanks, Bob. A couple of other concepts make that option attractive. Once applied to any cell, that workbook will have the custom format available to use in the custom format menu, even if all the cells using it are cleared of formats. Also, it can be applied in several different time-saving ways.
A macro with a dedicated button and/keystroke to apply it to any selected cells (tho that's not as good an option for beginner's).
Or, use the dialog box to apply to one, then use the format painter to apply to subsequent cells. Or, apply once, then use [ctrl]+[y] to apply it to subsequent cells.
Or, select all the cells that require it with [shift] and/or [ctrl], then apply the format either with a button or through the dialog box.
Or, if the rule for when to annotate is simple, you can build criteria into the custom format and apply to the entire column of values. Set it and forget it method.
Of course writing complex criteria in VBA to apply as needed is an option for some, but not most.

However, the cons for using it is the learning curve. It's not any easy system to figure out how to apply criteria beyond the basic positive, negative, zero, non-number syntax And it can be difficult to troubleshoot, modify, or even understand how it's working if someone else inherits the file. I try to make my files user friendly to the next sucker, I mean user, down the line, but sometimes all you can do is implement the complex solution, then add comments. Better still, use a separate tab to make notes. This sometime saves you the embarrassment later when someone asks how something works and you can't remember. That happens a lot.

But now I'm off topic...
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match two sets of data and display specific data lolly150 Excel 1 05-14-2012 10:33 PM
Move data from 1 cell to another cell Catalin.B Excel 1 06-25-2011 12:51 PM
Display a label character in a data cell Word 2010 - Cell hover display question Jacob91 Word Tables 2 05-01-2011 09:42 PM
Word 2010 - Cell hover display question Jacob91 Word 0 09-02-2010 09:18 AM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft