Placing checkbox on Flexgrid

P

Pranav Vaidya

Hi,

I am trying to place a checkbox on a flexgrid using the following code.
Everything works fine, but I cannot see the checkbox. Can you please let me
know what am I missing here?

I have 11 columns in the grid and I want the checkbox to be on 1st row after
heading row and on the last column.

Dim NewCheckBox As MSForms.CheckBox
mshflgrReport.Row = 1
mshflgrReport.Col = 10
Set NewCheckBox = Me.Controls.Add("Forms.checkbox.1")
With NewCheckBox
.Name = "MyCheck"
.Caption = ""
.Top = mshflgrReport.Top + mshflgrReport.CellTop
.Left = mshflgrReport.Left + mshflgrReport.CellLeft
.Width = mshflgrReport.CellWidth
.Height = mshflgrReport.CellHeight
.Font.Size = 7
.Font.Name = "Tahoma"
.BackColor = &HFF00&
.Visible = True
.Value = True
End With

Thanks in advance,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - (re-) Set a Table Style 2
VBE tricky question 2
Checkbox displays 'check' instead of the assigned caption 0
Delete rows in table if checkbox value in first cell equals true 1
Problem with protected-form checkbox on single row of table 2
Word 2002 Adding a Frame to a Frame 0
Dynamic fields on forms 5
add worksheet checkbox and change parameters 13

Top