I have large list of values to add to a drop-down list but they wont
all fit in the Data Validation box, nor do I want to reference a range
of cells, so can you please provide some syntax for doing it through
the VBA.

With a cell selected in a bold header row, clcking the 'Sort Ascending'
button on the toolbar does exactly what I want.
It would be great to be able to put something this into a macro
   Cells(2, 3). Sort, Order1:=xlAscending

I have about 1,000 to 1,500 records in Excle 2003 that I am trying to
get into Access 2003 using VBA the fasted way possible.  Right now I
have an INSERT query that loops through the records but this is very
slow.  I have read about some other options that would be faster like

Is there a way for a user defined function to tell what cell its being run
from?
For example if cell C3 is set to =MyUDF("x") is there a way for MyUDF to
figure out that its running from C3?

Public Sub FindTheGreen()
Dim c As Range
i = i + 1
For Each i In Range("A1:A1000")

say you have an object, and you want to call a method, but that method
name is a string.
is there a way to execute this method?
obviously, you can't do

I wonder if this is possible. I am a newbie by the way.
Addin1 has a function called obj that returns an object that is
created with methods etc.
Public Function obj() As MySpecialType ' type from tld com interface

Can anyone give me any appropriate example why the Save Workspaces is
used.
Whats the Purpose
and in which circustances they are being used

I have been trying to get the following to work but when clicking the
Yes to All the userform re-appears each time it performs the routine.
Anyone know how to get it to appear only the once?
Module code:

Is it possible to make a hyperlink from a cell to an exact Powerpoint slide,
not to whole PPT-file ?
-Sami

Not sure where to start. Need to take text input description large amount of
text. Have a way for user to input then insert it into a cell after.
Ready for any ideas.
Thanks

I'm trying to count the number of times a sequence of characters occurs in a
cell.  The sequence could be surrounded by non-printing characters, and/or
could appear more that once in one string (ABCblahABC  SDF ABC blah).  
I tried the following, but it seems to "miss" sometimes.  ...

I have a need for conditional formatting based on greater than 6 conditions
and have found VBA programming on http://www.ozgrid.com/V (*thank you very
much!*) and modified it slightly.  It works perfectly for the data manually
entered in the cells in the Target Range.  However, I ...

My problem is illustrated here with a form that  contains a textbox and
a spin button.  The spin button updates the variable Mnth, sub
FormRefresh updates the form with new values, and returns the focus to
the text box..  However, focus isn't always returned to the text box,

I am not sure which way would be best for this... worksheet functions of VBA
Here is the situation,  I have a large text file that I need to break info
out of.. This is not comma, or easyily delimited files, so I need to figure
out how to do this (I have kludged something, but it ...