MyVariable = Trim(Mid(data, (InStr(data, ",") - 1)))\
This is the string in wich im trying to Take the date out of,
secondname,thirdname,Mother:1,childname,10/12/2007,
However sometimes it might look like this  depending on user input

I don't mean it in the syntax way but conceptually can
worksheet_change be in public scope?
Instead of copying and pasting the same code for each sheet vba
coding, I was wondering if there's way to put worksheet_change in

I have text info in my excel text box, but I can't do a word search in
the text box.   Any ideas.   What about inside my cell notes?

I hope someone can please help me with this.  I have a userform with a
multiplage that consists of 4 pages.  My controls consists mainly of text
boxes and Frames with checkboxes.  I need to know how to add the checkboxes
to the worksheet.  below is a sample of the code I have to ...

First, forgive the Repost.  I didn't get any replies over the weekend.
I am trying to get the horizontal scroll bar on a MultiPage page to work. I
have a main MultiPage (MultiPage1). On each page of the main MP there is
another (sub-) MultiPage (i.e. MultiPage2 is on Page1 (index ...

I have a Userform that pops up when a cell is selected. Is there a way to
have the Userform NOT pop up if the cell is selected with code that reformats
that particular cell?

Hi,
If I have an array of number, for instance grades(25,10,30,22), is there a
function that I could use to tell me which position of the array list
contains the smallest value? ie. in this case, it will return 1 as 10 is the

CP will always be found in column "A"
There will always be only one occurrence of CP in the range.
It will always be found.
Need to see if the sum of columns "B" through "L" in the row CP is

Each week I have to prepare a "Master Summary" report in excel that
takes data totals from 6 other database systems including multiple
Oracle instances, SQL Server and MySQL databases. The data from each
is independently queried, grouped, pivoted, sliced, diced and totaled

I have a Excel VBA program that is executed from several different personal
computer.  What would make the Excel VBA buttons larger one personal computer
from another personal computer executing the same program.
Thanks,

I've written a MS-Project VBA macro to export data to MS-Excel.  The macro
works fine.  The performance is good...until I get to the PageSetup section,
then the performance drops.  The entire macro takes 26 seconds to run, but 16
seconds of that are used up on the PageSetup ...

i'm working with office 2007.
i have big .xls file. (about 8000 KB) , i had a strange problem, suddeenly
it becames 11000 KB. I used the same macros that i'm using for months.
it happens for another person i know with other file.

I have purchased the code for the data entry form from j-walk. I have
make a few small changes to the code. I am generally happy with the
form. However, when the enter key is pressed during the entry of a new
record. the form closes and returns to the spreadsheet database.

CAn anyone point me to a good reference site/material on the different form
controls (Listbox, group box, label, etc) and how to set those properties
(such as setting the text, color) using VBA?  
Was trying to navigate through microsoft's help online, but is quite

I am working on a script to transfer a *lot* of data between excel and
MS Access. Currently it has a lot of loops, transfering a single value
each time, for example:
   Set cn = New ADODB.Connection