PC Review


Reply
Thread Tools Rate Thread

Can a checkbox be placed 'within a row'?

 
 
Dan R.
Guest
Posts: n/a
 
      8th May 2007
What I'm trying to do is place checkboxes in the first column of my
spreadsheet so that the user can check the box if they want to process
the data in that particular row. Probably not possible huh? Any
suggestions?

Thanks,
-- Dan

 
Reply With Quote
 
 
 
 
Tim Williams
Guest
Posts: n/a
 
      9th May 2007
Does the sheet need to be sortable ? If not then you can use option buttons
from the forms toolbar

You could try something like this:

'***********************
Option Explicit

Sub Tester()

Const R_START As Integer = 3
Dim i As Integer
Dim c As Range, s As String

For i = 1 To 10
Set c = ActiveSheet.Cells(R_START + i - 1, 1)
s = "chkBox_" & Right("000" & i, 3)

On Error Resume Next
ActiveSheet.CheckBoxes(s).Delete
On Error GoTo 0

With ActiveSheet.CheckBoxes.Add(c.Left, c.Top - 1, 15, 15)
.Characters.Text = ""
.Name = s
End With
Next i

End Sub
'************************


"Dan R." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What I'm trying to do is place checkboxes in the first column of my
> spreadsheet so that the user can check the box if they want to process
> the data in that particular row. Probably not possible huh? Any
> suggestions?
>
> Thanks,
> -- Dan
>



 
Reply With Quote
 
Dan R.
Guest
Posts: n/a
 
      9th May 2007
This is perfect Tim, thank you.

-- Dan

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkbox Control - How to display a true or false value in the cellcontaining a checkbox Dave K Microsoft Excel Discussion 1 8th Sep 2010 08:31 PM
Count of records where checkbox 1 is unchecked, checkbox 2 is chec EllenM Microsoft Access Reports 1 24th Mar 2010 03:23 PM
Coordinate status of checkbox on form to checkbox on multiple reco DanRoy Microsoft Access 0 4th Sep 2008 09:18 PM
DataGrid and embeded Checkbox..How to find if checkbox clicked =?Utf-8?B?RG90TmV0RGV2?= Microsoft ASP .NET 1 6th Oct 2006 05:11 PM
Master-Detail Datagrid -checkbox (once tick the checkbox, all the child checkbox is ticked) Agnes Microsoft VB .NET 0 16th Aug 2004 11:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:20 PM.