how to make a custom function(vb script) available globally (as in used from
every workbook, without having to add the module manually)

I'm attempting to make a budget in Excel and would like to format a cell to
turn bold and red when the sum equals a negative number and for the cell to
turn bold and black when the sum equals a positive number.  I believe there
is a way to do it but I'm not sure how to go about ...

in Cols B1, C1 & D1 I have  dates 01/01/2008, 01/02/2008 & 03/01/2008,
in Rows A2, A3 & A4 I have names Tom, Dick & Harry,
In cell A10 is the value 'Dick'
In cell A11 is the value '02/01/2008'

thanx bob ur code works...
but now how do i change it to go and check on sheet named "inputpage" for
row a and b?
im going to put a cmdbutton on about 10 or 12 sheets and need this macro to

I am using a version control system (SVN) to separately control my
template spreadsheet and my VBA .bas source code.  I rarely change the
xls, but make many changes to the bas including client specific
branches.  I need to track the code changes.

I had hoped to do this with Conditional Formatting, but it does not seem to
be allowed.
If cell A3 is not blank I want to change the border format on cells A5, A7
and A8 with the lines which in effect crosses out the cell.

How can I make the following line of code randomly choose the tab color
index? I would like the code automaticlly color the tab not me choose it.
.Tab.ColorIndex = 3

Does anyone know where I might find a list of what number equals what number
in VBA?

I use a personalized Userform to edit data on a "Summary" sheet. The userform
collects data from the sheet so it can be edited.
The Userform works fine on the Summary sheet, yet when I activate the form
from another sheet it selects cells on that sheet rather than the Summary

I have a function to combine two 3d arrays. Is there a more efficient
way to do this than the code below?
Note: there's a complication:
The 3rd dimension includes a price. When combining the arrays, if the

Please, explain me about IF Condition in Excel.
Regards,
Krish

I need help with code to search for only the left 2 characters of all rows
within a single column to use as a reference for another search code. So if
the user selects say EM from CbxDept, I want the code to find all the rows
with EM in the first 2 characters, then the second ...

I would appreciate any help you are able to offer. I am working on a
spreadsheet that should displays YTD figures for each month selected.
I have already got help with displaying YTD figures based on Year
Beginning from January and ending December. I now need to be able to

i got a userform. with a cmdbuton on a sheet named "verify" column a down i
got 50 words. and column b i got 50 difrent combinations of 4 numbers. i need
the folowing code. 1 when i click the cmdbuton it needs to call the userform.
2 when it opens up in one block randomly go and ...