Is it possible to have different messages pop up, e.g. if cell a1 = 1, a
message will pop p showing "Correct" with red bold text, if cell a1 = 2,
message popus will show "Incorrect" with blue bold text etc.
Thanks in advance of any help.

Good day --
I used the subtotal functions to generate the following report.
What I would to instead of having to insert page break of each group,
is have it generate a new worksheet for each group, and change to tab

What is the best way to get some code to run at timed intervals?
I have used the following code.
Application.OnTime Now + TimeValue("00:05:00"), _ "time_set",
TimeValue("22:00:00")

Heya!
I have been trying to get some feedback regarding my issue with having
a VB userform do the VLOOKUP to fill in the other TextBox1-9 based off
the value of TextBox10. Now I have searched the boards over and over

I am trying to create from Excel 2003 a link to a Access 2003 table.  I
then wan to append that linked table to another table and have the temp
table deleted.  This is in an effort to find the most effecient way to
insert a lot (1,000 -1 ,500) records from Excel into Access with the

I need to replace the font of one character in a text string in a range of
cells.
I can do this character by character by hand but I want to automate it.
If I use the replace function for one character than the font change is

Hello Fellow Programmers! I am having a difficult time trying to get my
user form to search through a spreadsheet and retrieve the information
using the Application.Vlookup code...I have searched numerous other
posts and haven't found one code that worked the way I needed it to.

Hello fellow programmers!
I was woundering if any one knew some code to allow me to do the
following...
I have 10 employees with 10 unique user names and 10 unique

I don't get it. I am just trying to debug a macro. So I press F8 to initiate
the "Debug - Step Into" mode, and everything is working as expected until I
hit a MsgBox statement that just displays a message and an OK button. As
soon as I press the OK button, VBA seems to 'forget' ...

I would like to have a detail page (on a userform) appear upon opening an
add-in for the first time, but then the user can check a box on the form to
not have it show again.
Is there a way to preserve the value of a variable after excel is closed?

I am not a programmer.  I typically create macros and do minor VBA editing to
make things work.  
I've created a macro that searches a column for specific occurrences (",")
and replaces them with a comma and a space.  The problem is that one cell

I am fairly new to vba and I have found that vba is the greatest thing
in ms excel, wow. Anyway I appriceate everybodies help. I am trying to
email excel sheets using vba and not using outlook or any ms email
application. Does anyone have the code to simply email documents as

Sub RunAccessMacro()
Dim appAcc As Access.Application
'Opens Access or gets reference to app already running
Set appAcc = New Access.Application

I am fairly new to vba and I have found that vba is the greatest thing
in ms excel, wow. Anyway I appriceate everybodies help. I am trying to
email excel sheets using vba and not using outlook or any ms email
application. Does anyone have the code to simply email documents as

I copy a text file and then run my code to get it to my database. I
want to do it for all ".txt" files in a specific directory. Lets say my
directory is "c:\bcf"
1. Get the first ".txt" file - copy it to "sheet2"