In one macro I would like to get external data from Access, and use that
data. I am able to perform an Access query on its own, but it doesn't seem to
update until the macro is finnished. This means that I cannot reference the
data the I am calling. While the macro is running ...

I have a button on a userform.  When the user clicks said button it
copys the page and pastes it into a new workbook.  My dilemma is that
it does not format the columns the same as the source.  I have tried
recording a macro where I select that particular option from the paste

Is there any way to apply a tooltip (i.e. popup message when you fly over
it) to an autoshape?  Wanting when my user moves his mouse over an
autoshape - to get a hint of what it is?
Any/all pointers greatly appreciated.

I have a group of four option buttons on a userform.  The user is
required to check select one of them.  What can I put in my code to
verify this.  What I currently have is below but it does not seem like
it is the most efficient way of completing this task as I have this

I'm working on a program that copies each line of a source sheet, and
depending on the first cell in the row, pastes it into one of 2 or 3
other tables on a different sheet. A userform (uf1021Mid) asks the
user for the info needed, including the location on the source sheet

I am using a combo box / Vlookup to populate a cell -say C3- with file name.
I want to use this to open the selected file.
   myFile = Selection.FormulaR1C1
   Workbooks.Open Filename:=myFile

Hi evryone
i m new 2 vba n excel m trying to solve some  problems as a part of my
problem i want to
copy range of data whenevr the difference of the activecell and cell

I'm setting in my FIRST Worksheet an object variable myRng1 by using code line:
Set myRng1 = Application.InputBox("Highlight the range you wish to Extract",
Type:=8)
This extract range ($P$80:$P$84) will remain the same for all successive

I know this is possible... I just don't know how to go about it because
'PrintForm' won't work...
I have a print button on the bottom of a UserForm. On that same UserForm, I
have a MultiPage with 9 tabs. They all contain more information than can be

Hi,
Am trying to e-mail a single sheet of a worbook to various people that i
have listed on another sheet in the same workbook. Am using excel 2007. was
using a macro made by a friend that doesnt work in 2007. when activated the

Through the valuable contributions of the MVPs and other members of this
group, I've learned a lot over the years- so thank you to everyone for your
ongoing participation and assistance.
One thing I picked up here was the following code to find the last used row:

I have this code...but I need to edit this code so the Insert Picture
Dialog box comes up and the user finds the picture...not how it
currently reads...this would automatically put a picture in without a
users choice....

On my desktop I have a master excel file. It contains code in ThisWorkbook,
SHeet1, Sheet2, Sheet3, Sheet4, Sheet5, and Sheet6. In a folder called excel
on the server (F:\excel) are 6 more simular excel files named Test1 through
Test6. The code contained within those files are ...

I was wondering if anyone know how to program into a macro a time-elapsed
bar showing the time left for a macro to run. I don't know the proper name
for this feature, but is the same seen when you download something. You will
see a horizontal bar that is filled in increasingly ...

I have two workbooks:  Source and Destination.
I use the following code to import a single row of data from Source
workbook, "Copreco Daily Reading Submission" Sheet 1, into the Destination
Workbook, Copreco Master Log, Sheet "Daily Reading Master Log"