I have a userform with multiple textboxes , I want to be able to highlight
text in a text-box and hit a button which would essentialy copy the text
string and based on which button I had clicked send it to the appropriate
designated cell in a spreadsheet.  If this is at all ...

Follow up:  I first added to original question, but it's really a new
question.
After using the code Debra was kind enough to share, I need to apply the
action (choose from a pull down menu and place each entry

I have this code working perfectly, which takes a variable (strToFind),
searches an array (Import_Data), and outputs all the matching records. easy.
There is also a function for reporting all values AllProjects_Report().
However, I want to include a checkbox labelled 'Exclude', ...

I wonder if someone can help me with this.
I try to read from a text file with this piece of code;
Do While Not EOF(1)     'Voer uit t/m de laatste regel van het file
   Line Input #1, strTemp     'Lees regel

(Sorry for double post. I realised only later that this group existed)
I'm using sendkeys in excel to send keystrokes to an application. I
don't send them with the WAIT as yes so control returns immediately
to

I'm trying to copy some data from excel into a table in word, I loop
through the excel spreadsheet and put the data into the word table:
       Do
           oTable.Cell(i, 1).Range = Right(ActiveCell.Offset(0,

I'm developing a financial calculator which has lots of VBA code, a few
charts, and some basic UI stuff.  It seems every time I open it and save it,
the size varies anywhere between 4 and 7 meg even though I open it with the
Shift key held down, and I have ThisWorkbook ...

I have an Excel file that contains a couple userforms and plenty of VB in
about 60 different Sub's. When I save the file the save process seems to take
about 3 to 4 times longer than saving an excel file without macros. Is this
my immagination or do UserForms, Modules, etc slow ...

I have recorded a macro that will make multiple formatting changes to a .csv
file and then save it in a new directory.
The newly created file will have a new file name each day based on the
current date.  For example, todays new file is "Outbound 02-22-07" and

I am learning VBA and I just created several templates/forms (sheets) that I
saved into an Add-in.
The Add-in creates automatically a menu item and I would like to be able to
call the templates (sheets) saved in the Add-in from this menu.

Hi, I have an array called Runer which I redim(1 to 5, 1 to idex),
Idex bieng the number of times I count through certain scenarios. I
then use:
j = 1

activecell is J113
how can i replace J113 with ab?
i don't know how to arrange the double quote.  Thanks a lot.
ab = ActiveCell.Address

.....No error message is received either!
The code hits the following line:
Sheets("xxx").Copy
...then a couple of events are fired and the event code runs.

excel 2003
have long lists of data entry (column one days, column two week average),
need to be able to drag down along column (B) rather than retype specific
cells to average, problem comes in when dragging it will average 2:3

Have column of calculated figures, some of which have manually set custom
format to a different colour. How can I NOT include these when doing further
calculations, eg. am searching array using vlookup and if statments but if
result is cell with custom colour want to give warning ...