Hello everyone, I need help. (who doesn't, lol)
I am trying to build a macro to
create real estate trend charts/graphs. I need to work with different
amounts

I'm sorry I dont write english very well, anyway I need to create a
graphic that It have two scales. The axis X is the time (1 2 3 4 5 6)
to  Y1 and y2.
These axis Y1 and Y2 are input values for example (y1(rainfall)=0.1

Sorry but I have to try to ask this question again.  I have had usefull
information from some members but no resolution and this is the last
stumbling block,
I do not know how to say it simply that I feel conveys what I need but here

Yes you are correct, when I hover over visitlist and invoicelist it shows ""
- could that have something to do with the fact that I am trying to clear the
data when saving.  The list box (combobox) is on the form but it does pull
its list from a sheet.  If I have to set focus or ...

I am doing the following:
Call SortListBox(.ListBox1)
.ListBox1.ListIndex = 0
MsgBox .ListBox1.Value  '*** IT RETURNS NOTHING ***  WHY????

I use the following code to export a series of sheets from my Master book to
a client package that is emailed out.  It works great, except that when the
export occurs, it also exports controls (buttons etc).  How can i prevent
this?

I Have a range of Numbers
in Col A  ( A1 : A1631 )
in Col B ( B1 : B384 )
I want to delete duplicates that appear in Col A from Col B then delete Col

I am new to Excel programming and was wondering if this is a valid
Excel IF statement for what I want to do:
"=IF(AND(RC[-4]=""NJ 07733"",RC[-12]=""981621""),""HOLMDEL"",RC[-3])"
If cell, 4 cells to the left of the current cell = "NJ 07733" AND

Basic and simple question, but have forgotten.
How do you hide any open sheets, when opening a workbook?
Thanks

ROW     A         B        C       D           E         F--col
1         CODE   CO      AC     FO       CR (-)    DR (+)
2           1LD      M       X1     GGG   -1000     2000
3           1LD      M       X1     GGG   -2000     4000

I would like to update the status bar from within a user defined
function.  Application.StatusBar works for macros / subroutines, but
does NOT work for user defined functions as best I can tell. Is there
an equivalent call? Any help will be appreciated.

My UserForm has a ListBox control named lbox.  In the click handler of
another control on the same form I call a subroutine that has lbox as one of
its parameters.  I get a "Run-time error '13': Type mismatch" and when I go
to debug mode and float the cursor over "lbox" in the ...

Hi , can please anybody help me with the macro.  I explained every
thing in an excel sheet which you can see in the link below. As I
thought its better to put my question on a sheet to explain clearly.
http://www.savefile.com/files/1511153

Hello
I have some code that was given to me and I have modified.  I am trying to
modify again and I am having trouble.  I am opening files manipulating data
and then copying to another workbook where inthe macro lies.  All of the

Can anyone help identify why this is not working correctly.  Following is the
full code from the form. Myself and another member have worked on this but
can not resolve the problem.
This code is used for a 2 page form that takes information from the sheet to