has anyone a calculation for the phases of the moon, especially first
quarter and last
quarter of the moon?
Thanks,

I need my cells to to have data attached (like a string of values), this data
will differ from cell to cell; how do I do this? I believe there's no such
thing as a 'custom property' placeholder...could I use 'Comment' for this? Or
is there a better way? Or a code sample? Thanx a ...

I am looking for code that would check for todays date in column A and if not
found put todays date in the last blank row on the sheet and then put values
of "Count1", "Count2" and "Count3" going across in the same row, columns B,C
and D. If it finds todays date do nothing.

Hi, all
I am working on an application in Excel and I add a new toolbar to
excel by coding VBA. Here's the way that I wrote like:
   Application.CommandBars.Add Name:= "My Toolbar", Temporary:=True

I have a total of 8 Textboxes and 1 ComboBox in a UserForm.  Textboxes 1-4
show calculation results that are dependent on Textboxes 5-8 and the
ComboBox.  I am currently using the Change Event in Textboxes 5-8 and the
ComboBox for an instant calculation for the user to see.  My ...

If I want to loop through a column of data and dependant on the value
of the active cell, fill that row with a value, how would I write the
macro?  I can loop through data, but am not sure of how to make sure
the active row is filled and no other, then the next cell in the

I have an invoice template i designed. I want the total amount in figure to
translate automatically in word in another cell i.e amount in words - without
a manual imput for the amount in words

I have a field that contains a set of numbers, and I would like to display
those numbers in a user form in different fields.  These would not be
editable, nor do they need to be saved, this is just for display purposes
only.

I have written an Excel VBA script that will create and update Outlook Task
information based on other details in an Excel spreadsheet.
I need to find a way to remove the following security prompt that is
returned when the script is run...

When I see sheet 1 in excel, and I scroll down so that I see for example row
35, I want to see the same row (row 35 in this example) when I go to sheet 2
(or another screen).
How can I do this,

I'm trying to make a function that compares two string expressions. HOWEVER,
I don't want the -1/0/1 returns that I get from the StrComp function. I would
like some sort of index or percentage that shows how similar the two strings
are. Has anyone done anything like this? Any ...

Hi NG
Is there any way to test in VBA if an entire row has been selected? I tried
with something like
If Selection.EntireRow = True

I need cells linked together based on their values.
I've made up the following scenario:
select a cell (e.g. C4); invoke a macro which decremets the value in C4 by
one; another cell (e.g. A2) is somehow 'linked' to C4 and so is decremented

I am facing a peculiar problem. I sent one of the Excel files to one of my
friend which contained some dates (dd-mm-yyyy format) but when he opened the
file the dates were converted to text (mm/dd/yyyy format). I had done some
calculations on the basis of the dates and now they ...

I have to develop an application using VBA/EXCEL and I want to protect
as
much as possible the code. Macros are in the spreadsheet itself (just
a few like auto_open) and in a separate xla file.