Check Box
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
|