I would like to add different colours to different numbers in an excel sheet.
So for example "1234" should be green every time when these determined
caracters (numbers) appears on the sheet.
Can I do it? And if yes, can i match more determined caracters with

Good afternoon, all,
One column in my database ("ColStatus") is validated by a drop down list,
and depending on the value selected, I want the interior colour for all
database cells in the target row to change. In the code shown below, the

We have developed a VBA-program in Excel 97 which works fine in Excel 2000
and Excel XP but when we test it  with Excel 2003 we recieve the error
message
"Compile error in hidden module: Module 1".

I had some pretty good help on this problem and thought we had it nailed,
but a slight problem still remains.
I need a message box to appear when two amounts do not match and I need this
to happen as the amounts are typed in.

This forum's brilliant... I haven't Not found an answer to an excel/vb
problem here yet!  Thanks everyone...
So, I have a named range on a sheet, and a combobox with data
validation on the named list.  Having the named range on a different

Im pretty new to vba, and im currently working with somebody elses
code, which is supposed to work but has decided to stop.
I get the error from the title at the highlighted code, even though the
previous code uses the same pivot table, can anybody help me with ths

Hello all,
I'm a beginner in the realms of user-defined formulas.
My problem is that the one that I just wrote doesn't update when its
arguments are updated: it will only update when I edit the cell it is

Hi
I got a workbook which I would like to disable the option of showing
the Tabs button as well as some other option found under the option
menu so that an advanced user can not enable the show tabs option. I

Let's say that I do have list of analytes with names
1,2,3-Trichloromethane.
I would like to short this list, I don't want the integers on the
front, just the string part of it.  

Hi,
I was wondering if any one could help me, I have some data which was
inputted incorrectly and I need to amend it, there seems to be a
pattern, its missing the number 1 before the number eg 31456 should be

I have two ranges in two sheets within the same workbook that need to be
cross-checked after automatic data replacement. If a value is not found in
range 1 it needs to be appended to range 2. I looked at looping (While ...
<> "") but it seems a tad slow. Can soomeone recommend a ...

Is there a way to determine the number of rows of text displayed in a cell
with the wrap text property turned on?
I was thinking of other ways to get multiple rows... alt-enter , and I think
if you take the string of that and count the char(10) count, you could get

I'm having a porblem with a workbook that uses the Outlook Object Library (MSOUTL.olb). In particular, the wb has references to the Version 10 file. Now that a new computer on the network has Version 11, it is causing a few incompatibility issues.
In particular, when the workbook, ...

Is there anyone who could help me to have a check voucher template?
Thanks

Does excel have an interface to directly accept data from a barcode reader