I have a new module, consisting of many "subs"
Each one is actually quite small, but very understandable, since each one
refers to one sheet.
Question:

I have the following piece of script that brings up a prompt when
someone fills in a particular cell (in this case G10):
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)

I have a piece of VBA code that does the following: It adds to the Worksheet
Menu Bar a control of the type msoControlPopup (i.e. a new menu), and then it
adds to this new control a control of the type msoControlButton (i.e. a new
menu item).

Hello.  I'm trying to format the date entry in a textbox on a form s
that when a future date is entered via the form onto the relevant cel
in the active sheet, it will always show in the following format
'01/mm/yyyy' in the cell.  The first day of the month should always b

has anyone got a macro where I can import a text file saved on my
computer into a new sheet named yesterdays or todays date in format
"ddmmyy" and then the sheet gets hidden.
Thanks in advance for your help

I am producing a basic financial model where the amount of debt and
capital is dependent on the cash flow, which must have a minimum value
of, let's say, 1000. This, of course, generates circularity because of
the financial costs of debt:

Think this should be quite simple for some the guru's here :D
What I have is this
A    B   C   D   E
1      X

All,
I realize this may be a little "off topic" but does anyone know how to
find the entry points for HHCtrl.ocx. I am trying to use it as the Help
Viewer for an Excel .chm help file that I created.

Maybe somebody can help me with the following:
In the main sheet I've made an totall array which has to be filled from
other arrays standing on different sheets. Normaly that is not so difficult
by using (V)lookup-formulas but now I've to check 2 parameters from the

Lets say I have an excel spreadsheet file that consists of a number rows with
text, each of which is painted in either of two colors: green or red. I want
to remove those rows that colored in red. how can I do this?

Hey all,
I got this problem.
Every day i have a Macro creating a logfile, that contains the date of
today.

i am a new user to excel vba programming.
i have a excel sheets with some fields like name ..... date...etc
if i enter date cloumn into the excel sheets then i need to delete tha
row  form that  sheet and  same row need to be inserted into anothe

I am looking for the next solution :
I have an excel sheet which gives me :
 A               B
Name 1    Problem 1

Help would be gratefully received for the following:
I want to import data from a csv file.
When I do this manually (using File -> Open -> Text Import Wizard etc)
the date data comes in fine.

i have got a new problem this time. I have managed to populate the data
and all in the Combo box and its doing first letter select. but the
trouble is earlier in the list box (form type) when i used to select an
option i used to set the data in another cell.