Question 1 - Checking of a checkbox depends on what type of a checkbox you
have. There are two kinds. One is from the Control toolbox and and the other
is from the forms toolbar. They work differently so we will need to know what
kind you have. Right click on the check box if you have a "Properties" in the
list then you have use the Control Toolbox.

Question 2 - My prefered method is to use a range object to move around a
sheet something like this...

dim rng as Range

Set rng = Range("A1")
msgbox rng.Address
set rng = rng.offset(1,0)
msgbox rng.Address

Recorded macros use the active cell but that is not nearly as handy as range
objects. To move the activecell you can use something like

msgbox activecell.address
activecell.offset(1,0).select
msgbox activecell.Address

--
HTH...

Jim Thomlinson


"NoProgram" wrote:


I already asked this, but perhaps I didn't ask it correctly. I'm a
teacher and I have very little programming experience. I'm trying to
create a macro in excel that will take data that I will import, check
it, and then check off a checkbox if it exists.

Basically all I need to know is the command line for actually ticking
off (or checking the checkbox). Such as : Activesheet.checkbox1. ??

Also if someone could explain to me how to increment cells in a row,
that would be VERY helpful. I need to move from cell A1 to B1 and so
on. So I just need an example of how to increment these cell numbers.

Thanks to anyone who can assist.


--
NoProgram
------------------------------------------------------------------------
NoProgram's Profile: http://www.excelforum.com/member.php...o&userid=33832
View this thread: http://www.excelforum.com/showthread...hreadid=536170