Free Microsoft Excel 2013 Quick Reference

Creating macro in Excel that can add a check mark

There is a Macro found in Word (see fax sheet template) that will create a
check mark in a box if you double click on the box. Does anyone know how
translate this macro into Excel?

I am using Word 97 SR-2 (behind the times a bit....)

Post your answer or comment

comments powered by Disqus
I would like to create a macro in excel that loads a specific word document
in MSword! Any Ideas?

Can you write a formula in excel that can reference the source/or dependent cells of a specific cell?

In other words: I label my tabs 1,2,3,etc. If I link cell A1 in tab 1 to cell A1 in tab two I would like to be able to write a formula in cell B1 of tab 1 that tells me that cell A1 is linked to tab 1. For a bonus I would like to be able to write a formula in C1 that tells me any cells that are using cell A1. For example if tab 3, A1 was linked to tab 1, A1.

To put it in to formula terms:

Cell A1 of tab "1" would look like this: ='2'!A2
Then I want to write a formula in Tab "1" Cell B1 that results in: "Tab 2" or even "Tab 2 Cell A2"

Can anyone help with this?

I have a formula that will put the name of a tab in a specific cell. This is great for tables of contents and creating titles to documents or footnotes, but it is a pain staking process to use this formula for the above purpose.

That formula looks like this:


I am currently using 2007.

Thanks to whoever is smart enought to figure this out!

I need help creating macros in excel. What I am trying to do is create a
loop (I think) to do the same thing in a column, say every 2 cells. For
example, I would like to take column C, and delete the contents in every
other cell. (delete C2, C4, C6, etc. for the entire column).
Any suggestions would be MOST helpful.

i would like to know how to create macro in excel to disallow input of numbers by the user. the user is allow to enter characters except numbers. pls list the steps to guide me through. thank you

I am trying to create a form that has boxes in which people can enter a check
mark by simply clicking on the box, no text required. I'm using Excel 2003.

Background: I have some Word files uploaded on SharePoint. I'm
creating an Excel Sheet that consists of all the procedural steps in an
upgrade process. Certain steps I can write in, but others need to link
to those Word files. After the project, no one will have access to
SharePoint so the files will be saved on the users' laptops.

Goal: I'm trying to create links in Excel that point to a folder saved
on my laptop and in that folder are maybe 10 Word files. My goal is to
create a variable in Excel so any user who has all those files saved on
their own PC can access this Excel Sheet and input the directory drive
as the variable. For example, if all the files are saved under
C:DesktopMy DocumentsSAP ProjectWord File Links, then variable x
will equal that whole location. Then, I want each link to point to the
variable x + name of the Word file. That way, when the user goes
through the Excel Sheet step by step, they only have to input x once
and whenever they reach a link, they just click on it, and it opens
that Word file.

Problem: In Excel, I can't insert a hyperlink that allows me to add a
variable to a text cell. And when I try to Edit --> Links, Links is
grayed out and I don't understand why. Please help.


Does anyone know how to write a macro in an Excel file which can copy and
append the data in an Excel worksheet to an existing Access file? Also at the
same time, a graph in that Excel worksheet is linked to a PowerPoint file. So
when the macro is run, I hope both the Access and PowerPoint files will be
updated automatically.

Since I am doing some works which require data analyisis by using Excel, I
currently need to copy and append the data to the Access database manually.
Also I copy the graph from the Excel file to the PowerPoint file manually as
well. It would be great and save a lot of time if one macro in Excel can
manipulate between Excel, Access and PowerPoint?

Thanks and regards,

Trying to create a cell formula from VBA that can return a cell reference or a text value. Since the formula I'm creating is bracketed by quotes (""), I can't put the text value (NA) in quotes. Is there a special wildcard to use to accomplish this?

Thank you,

Tony R

I've installed Excel 2007 on several PCs and written lots of macros in Excel 2007, and never had any problems. Today I installed it on a new PC. I've set macro security to enable all macros, and added the developer tab to the toolbar. However anything to do with VBA - record new macro, visual basic editor etc - is greyed out, as if I hadn't set the security option. I've closed and reopened Excel and the option is still set, I've rebooted, but it won't let e create new macros. Have I forgotten another setting somewhere?


(Vista Premium, McAfee Internet Security installed)

I am trying to create button in Excel 2000 so it creates a new appointment
in Outlook 2000. Is this possible?

I am trying to create a macro in Excel that when executed changes the desktop picture in my PC.
The picture that I will use resides in my local workgroup network.
I am using MS Windows 7; I would like to use the "Assign Macro" VBA module tools in MS Excel 2011.

Thanks in advance.

Beginner needs help on a MACRO in EXCEL that will remove data points that are repeated and data points that are out of sync.

An example of how the macro should work on the list of data point rows is listed below.....

122.45 56 23 5677

123.45 66 88 7777

123.45 44 55 5445

133.00 55 33 3333

124.45 77 77 7777

125.45 33 33 7888

As you can see 123.45 is repeated we must delete the entire row where that number is repeated. Also, as you can see 133.00 is out of sync with the numbering system and that row must be removed.

I can copy and paste a large box that I can click and the the pointing finger
comes up and places a check mark in it, but it's too big, how can I create a
smaller box that I can do the same thing to?

i've never touched visual basic before, but i managed to take the source from
FindItAll (though i don't think it was the actual source seeing as how it
didn't work) and edit it to fit my needs.

looking to make a VB macro in Excel that will find a cell and move the
entire row that cell is in to the top. doing this for work, and my boss knows
i'm not a programmer. i think he wants me to learn. if anyone could point out
bugs or tell me commands, it would be much appreciated.

here's the code:

Sub FindAndMoveToTop()
Dim FirstCell As Range
Dim NextCell As Range
Dim WhatToFind As Variant
'Window prompt allowing user to define WhatToFind
WhatToFind = Application.InputBox("What are you looking for?", "Search", ,
100, 100, , , 2)
'If WhatToFind is a value and not blank, move on
If WhatToFind <> "" And Not WhatToFind = False Then
'Start with first worksheet
'Start at first cell
'Find the first cell containing WhatToFind (specified by user)
Set FirstCell = Cells.Find(What:=WhatToFind, LookIn:=xlValues,
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
'If FirstCell exists, move on
If Not FirstCell Is Nothing Then
'Ok, First Cell is set
'Keep going
On Error Resume Next
'NextCell is currently undefined. Don't mistake NextCell for FirstCell
While (Not NextCell Is Nothing) And (Not NextCell.Address = FirstCell.Address)
'Find next row containing what is in FirstCell (ActiveCell) and define as
Set NextCell = Cells.FindNext(After:=ActiveCell)
'Don't mistake NextCell for FirstCell, move on
If Not NextCell.Address = FirstCell.Address Then
'Activate subsequent NextCells
End If
End If
'Select all rows containing WhatToFind - NOT WORKING ARRGGGHHHH!!! only
selecting the cell, not the row.
'Also, if >1 instance of WhatToFind, acts funky...
'Cut all rows containing WhatToFind
'Back to A1
Cells(1, 1).Select
'Insert cut rows here
Selection.Insert Shift:=xlDown
'Clean up
Set NextCell = Nothing
Set FirstCell = Nothing
End If
End Sub

major problem is how to select ALL of the ROWS that WhatToFind is found in.
also, if WhatToFind is found in two cells in the same row, it will move the
second cell containing it in that row to the next unused row. idk. it acts
really funky.

i think Worksheets("Sheet1").Rows(ActiveCell).Select is the major problem
i think Cells(1, 1).Select might be causing the odd behavior for two cells
in the same row.

any ideas?

what i want to do is create a form in excel that would allow a user in a
different state to calculate how much thier state taxes would affect thier

for example user A lives in Chicago, so he goes to the sheet enters his
salary in the salary box, then there is a drop down that shows the different
cities and then chooses Chicago and the result at the bottom shows how much
his deductions from taxes are. if someone could point me in the right
direction i'd appreciate it.


I'm trying to write a macro in excel that will open a new outlook mail item
and populate the recipeint field. However, when it gets to this part of the
macro, outlook gives me a warning that "another program is trying to access
the e-mail addresses stored in outlook". Is there anyway of getting round

I have a check list in excel and wish to use check marks to siginify
completion of individual fields. How do I get excel to insert a checkmark
into a field when I double click that field?

We recently upgraded to Office 2007. I have a number of macros in
Excel. I just opened a spreadsheet I use periodically and I get a
#NAME? error in every cell with a macro reference.

These are my own personal macros. How do I enable them without opening
the doors to potential malware?




With the below script, this .xls will create a transmittal in MS-Word
by clicking a command button in column 'F'.

In column C, you may double click too add a check mark beside a file number which is
in column B, however when you double a cell in Column 'C' then create the
transmittal the numbers that the user checked off dont appear in the Word document,
what needs to be done with this script, is if a user puts a check mark in
column C, the numbers he/she put a check mark beside need to appear in the Word

And if the user checks off more than 3 numbers, the numbers
need to be listed on the second page of the Word document.

Most of the scripting is already done, the Excel document will already create a Word Document
and the check marks work in column C, the only thing that does not work is transferring the
numbers a user checks off, into a word document

This job pays, 70.00CDN

I am curious if there is a software package (for example, FoxPro and/or
Monte Carlo) or VB program/macro in Excel that can find a desired sum within
a column comprised of several rows of data. For example, if the following
were Column A in Excel:


and we wanted to find which combination of these entries (each used once)
totals 12, we know that 8+4 and 6+4+2 and 8+1+3 would be our combinations.
I'm trying to see if there is any other way than just "spotting" to see if
number combinations look like they'll match the totals.

Any ideas?


I'm trying to make a simple function for my company for inventory purposes.
Basically I have the numbers 1-320 down column A. I want to be able to scan with my scanner a serial number (all which will be a number 1-320) and have it find the number I scanned in the list and put a check mark (or an X or something) next to it in column B. Any ideas?


Ryan Smith

Set the ControlSource property of the checkbox to the worksheet cell you


Bob Phillips

"SallyP" <> wrote in message
> I hate to appear ignorant, but how do I have the checkbox write its state
> a cell?
> "Chip Pearson" wrote:
> > No, Conditional Formatting cannot get information from a
> > userform. You'd have to have the checkbox in the form write its
> > state to a cell, and then use the value of that cell in your
> > Conditional Formatting.
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> >
> >
> >
> > "SallyP" <> wrote in message
> >
> > >I want to create a conditional formula in Excel that evalutes
> > >form data;
> > > specifically, if a checkbox is selected, I want a specific
> > > value returned.
> > > Is there a way to do that? Thanks for any help anyone can
> > > provide. I'm
> > > using Excel 2003.
> >
> >
> >

how do i get the name of a newly added sheet that i add with Sheets.Add in a
vba macro in excel?

I use Windows XP Professional, Service Pack 3, Office 2003.

I must copy&paste thousands of times some charts from excel to ppt and i wanted to use a macro using VBA.

I found in internet some scripts that creates slides and objects in powerpoint from excel, so i tried to use them to understend how to handle powerpoint objects from a script in excel.

I've found this kind of script:

Sub Create_PowerPoint_Slides()

Dim oPA As PowerPoint.Application
Dim oPP As PowerPoint.Presentation
Dim oPS As PowerPoint.Slide
Dim oShape As PowerPoint.Shape
Dim sPath As String
Dim sFile As String
Dim i1 As Integer

sPath = "C:"
sFile = "MyfileName"

Set oPA = New PowerPoint.Application
oPA.Visible = msoTrue

Set oPP = oPA.Presentations.Add(msoTrue)

For i1 = 1 To 10
oPP.Slides.Add 1, ppLayoutBlank
Next i1

Set oPS = oPP.Slides(1)
Set oShape = oPS.Shapes.AddTextbox(msoTextOrientationHorizontal, 140#, 246#, 400#, 36#)
oShape.TextFrame.WordWrap = msoTrue

oShape.TextFrame.TextRange.Text = "Comments For File : " & sFile
With oShape
.Fill.Visible = msoTrue
.Fill.ForeColor.RGB = RGB(204, 255, 255)
.Line.Weight = 3#
.Line.Visible = msoTrue
.Line.ForeColor.SchemeColor = ppForeground
.Line.BackColor.RGB = RGB(255, 255, 255)
End With

oPP.SaveAs sPath & sFile & ".ppt"

End Sub
Before using this macro, I checked the Tools --> References --> Microsoft Powerpoint 11.0 Object Library.

Anyway, when I try to use this script, I get a run time error. It says that the library is not registered.

In my Italian version of office is:
"Errore di run-time '-2147319779 (8002801d)':
Errore di automazione
Libreria non registrata."

The line of code where it appears is:
I think VBA cannot use the PPT OLB library, but I don't know why. MSPPT.OLB is in my Microsoft Office/Office11 directory.

Thank you very much

No luck finding an answer? You could always try Google.