I am creating a program where there is a button in an Excel sheet that
adds a line to the sheet based on information from the user.
Information is obtained from a form. A new line is added with a check
box in the first column of this row and other information is added in
other columns, then the data in the sheet is sorted. The problem I am
having is getting the check box to follow the information after a row
is inserted and the button doesn't follow the information after the
sort. So, question 1: How do I "attach" a check box to a cell, so
that the check box moves when the cell moves?

question 2: I am having problems changing the caption for the check
box. I want there to be no caption. How would I accomplish this?

Thanks,
William

On the properties tab of the checkbox set the move with cell property.

Depending on the try of checkbox (control or form) you can also set the size
with the cell.

--
HTHs Martin


" wrote:

I am creating a program where there is a button in an Excel sheet that
adds a line to the sheet based on information from the user.
Information is obtained from a form. A new line is added with a check
box in the first column of this row and other information is added in
other columns, then the data in the sheet is sorted. The problem I am
having is getting the check box to follow the information after a row
is inserted and the button doesn't follow the information after the
sort. So, question 1: How do I "attach" a check box to a cell, so
that the check box moves when the cell moves?

question 2: I am having problems changing the caption for the check
box. I want there to be no caption. How would I accomplish this?

Thanks,
William

Thanks for your help, but I was wondering if there is a way to set it
using code instead of going to the properties tab.


Martin Fishlock wrote:
On the properties tab of the checkbox set the move with cell property.

Depending on the try of checkbox (control or form) you can also set the size
with the cell.

--
HTHs Martin


" wrote:

I am creating a program where there is a button in an Excel sheet that
adds a line to the sheet based on information from the user.
Information is obtained from a form. A new line is added with a check
box in the first column of this row and other information is added in
other columns, then the data in the sheet is sorted. The problem I am
having is getting the check box to follow the information after a row
is inserted and the button doesn't follow the information after the
sort. So, question 1: How do I "attach" a check box to a cell, so
that the check box moves when the cell moves?

question 2: I am having problems changing the caption for the check
box. I want there to be no caption. How would I accomplish this?

Thanks,
William

checkbox1.xxxxxx = value where xxxxx =property


--
markbpdx
------------------------------------------------------------------------
markbpdx's Profile: http://www.excelforum.com/member.php...o&userid=37610
View this thread: http://www.excelforum.com/showthread...hreadid=572037