Summary: Hi I have found the following VBA code to allow me to have more than 3 conditional formats. Private Sub Worksheet_Change(ByVal Target As Range) Dim ...
Summary: For the morning.... =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) lookup_value is whatever it is that you are looking up. In my exampl...
Summary: Currently i have a stopwatch(SW) created using excel vba. The SW has three buttons, one to start(cmdStart), one to stop(cmdStop), and one to reset(cmd...
Summary: Okay. Now I understand what you are trying to do. The only way I know of is to use VBA code. You would have to convert the raw number into a format t...
Summary: The Conditional Sum function will do this for you. As it's not loaded in Excel by default, you will need to add the Add-In 1. In Tools-Add-Ins make su...
Summary: Hi, Here is a macro that will copy formating from a master workbook to a series of other, named workbooks. I haven't tested if page settings are copie...
Summary: Hi, I need to switch between 2 open excel worksheets and copy data from one to another. I cannot use the file names to say which one I want to switch ...
Summary: Hi, I have a problem where I use the Find funtion (VBA) for when I want to refresh a record and return to that record. This works fine but it updates...
Summary: If I were going to do it, I'd use VBA to bring up an input box when the clicked the button, asking for a password. Then branch to a sub procedure matc...
Summary: I have found VBA code for entering time without colon however do not know how to limit this to colums C through F. The code I found results in undesi...
Summary: You could use the Style and Formatting Task pane. Then, all you'd have to do is select the text and then click on the formatting you want. Life is mo...
Summary: Google is your best bet, VBA for beginners netted about 500,000 results. It's also useful when just learning to record macros and study the code. ...
Summary: You can...sort of. Using VBA (Macro) Go to Excel Tools, Macro, Record new macro. Go to File, Open, browse to one of these files and open it. Make all ...
Summary: I am a Word pro, been using it for years and years and I can normally make the program do whatever I want with impressive results. I DO NOT understand...
Summary: Bryco's answer sounds like the perfect solution but I'm just curious about something. You used "vba" in your subject and "darned vba" in your post. Ar...
Summary: AFAIK you can not use VBA to check the interior color of a cell that has been colored via Conditional Formatting. One possible workaround is to use VB...
Summary: I am using Excel to help me record responses to some performance tests I give. In doing this, I have to record start and stop times, in seconds, then...
Summary: Unless you use VBA programming (Macros) you can't enter one value in a cell and have a different value show up. How would I set it up usin Visual Bas...
Summary: re: I assume that the LookIn:=xlValues in the macro code is what is being searched then copied/pasted. Wrong on both accounts. :) 1 - The .Find is sea...
Summary: Actually, for your string you would need to use: =MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&(LEFT(A1,4)) With your string in A1, click on the cell where you wan...
Summary: Hi I was wondering if anyone knows how to collect data from excel, and code it in VBA so it transfers it into a combo box in VBA, because i'm doing a ...
Summary: Since it appears that you are using Excel 2003, I'm pretty confident in saying that you can't do it with a formula. There are no built-in functions in...
Summary: Your examples and explanation are excellent. What books or reference material can you suggest for someone who is not logically minded, but who would ...
Summary: Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a lo...
Summary: Just a few tips... 1 - This is not "conditional formatting". Conditional Formatting is a specific feature found under the Format menu that will allows...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
