Hey people i am currently look at learning VBA in excel and i want to learn
on which microsoft course that is offered would be better for me???
Kind regards
Andrew

Is it possible to draw shapes on a userform? As far as I can figure it
out, it can't be done, but maybe one of you experts can. I did the
trick by drawing on a sheet and then making a GIF with the code of one
of you, then importing the GIF as a picture on the form. This is not

I need help creating a macro to find "ZZZZZCount" in column J, then select
the Rows from the cell just found to the end of the sheet (R65000) and
delete.  The cell location of "ZZZZZCount" will not be constant.
Thanks,

Hello.  I'm using Excel XP.  I don't know what's causing the error message
for following code:
If Application.IsText(ActiveCell.Value) Then
           sText = ActiveCell.Value

Hi.  I am creating a questionnaire in Excel.  In the first question the user
must choose for which department they are filling out the questionnaire by
marking an "x" in the cell next to the correct department.  Then for the
other questions, I would like to add that department ...

I’m using Excel 97. I’m not a programmer.  Using the macro recorder to learn
coding.  I’m working on a situation where I’m selecting data using the
AutoFilter.  Once the criteria  is made, I want to delete the rows selected.  
The recorder lists it as:

    I need data from Access. The Access query is based on a table that must be
created first using a Make Table query. How do I run this query from Excel
VBA?
I tried:

I have the following code to play a WAV file in excel:
Sub PlayWavFile(WavFileName As String, Wait As Boolean)
If Dir(WavFileName) = "" Then Exit Sub ' no file to play
If Wait Then ' play sound before running any more code

Hi, :)
Can anyone tell me the code for the arrow keys.
i.e, If i need to move the arrow key, what is the code generated.
To be more clear, I create a macro, when I use the arrow down key, it

I have several users access a set of workbooks. These workbooks contain links
to a different workbook. When they go to open the workbook, the receive a
message stating "The workbook you opened contains automatic links to
information in another workbook.  Do you want to update ...

I would like to exclude all comments except those in column G and include
blank cells too.  Can someone help me tweak this code?
Sub PrintCommentsByColumn()
 Dim cell As Range

I have a worksheet that contains a cell that I enter in different
company names such as (Costco, Sams Club, Jack n the Box).  Each of
these companys has a seperate worksheet with their addresses that I
want to lookup.  My question is:  Can you create a macro that takes the

I'm getting a compile error "Next without For" when I do have a
For!:confused:  Anyone have a clue as to why this is happening?  I've
attached the macro code I'm using and highlighted the For loop that its
having trouble with.  Also I highlighted the Next i in red where the

Is there a way to rearrange the order in which "links" to other
workbooks appear. Example I have a workbook that links to 52 other
workbooks. It starts in the correct order but then begins to go out of
order. This is a sales calendar that begins with Jan week 1 and so on.

Hi there - thanks for looking,
I have a large dataset with various columns of data for global climate
(meteorological) stations, however the dataset is not complete - it has
gaps for some years where data has not been collected/the equipment