Thread: Check Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kingwd@gmail.com is offline
external usenet poster
 
Posts: 2
Default Check Box

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