如何在VBA（Excel）中的MSFlexGrid列上显示单选按钮 [英] How to display radio button on column of MSFlexGrid in VBA(Excel)

问题描述

大家好，



我正在使用VBA（Excel），我有一个关于MSFlexGrid的问题我无法解决。



我的问题是NSFlexGrid列上的显示单选按钮。我可以点亮复选框，但我不能收音机。



你可以帮我解决这个问题吗？



提前致谢

解决方案

我担心不可能;）



模仿CheckBox：

 使用 MyFlex 
。 Row = rowCount 
 .Col =  1  
 .CellFontName =   Wingdings 
 .CellFontSize =  20  
 .CellAlignment =  3  
 .Text =  CStr （ False ） 或CStr（True） 
 结束 < span class =code-keyword>使用 

模仿RadioButton：

< PR e lang =vb> 使用 MyFlex
.Row = rowCount
.Col = 2
.CellFontName = Wingdings
.CellFontSize = 20
.CellAlignment = 3
.Text = Chr（ 162 ）' 或Chr（164）
结束

MS FlexGrid Control [ ^ ]



其他资源：

http ：//www.xtremevbtalk.com/archive/index.php/t-1316 00.html [ ^ ]

http://vbcity.com/forums/t/158470.aspx [ ^ ]

http://www.planet-source-code.com/ vb / scripts / ShowCode.asp？txtCodeId = 40094& lngWId = 1 [ ^ ]

http://www.vb-helper.com/howto_checkgrid.html [ ^ ]

HTTP：//forums.codegur u.com/showthread.php?208733-Placing-a-Checkbox-in-a-FlexGrid-Cell [ ^ ]

http://www.vbforums.com/showthread.php?443526-RESOLVED-Flexgrid-Checkbox-Wingdings [ ^ ]

Hi All,

I am working on VBA(Excel), and I have a issue about MSFlexGrid that I can''t resolve it.

my issue is display radio button on column of NSFlexGrid. I can diplay check box but i can''t with radio.

can you help me resolve this?

Thanks in advance

解决方案

I''m afraid it''s not possible ;)

To imitate CheckBox:

With MyFlex
    .Row = rowCount
    .Col = 1
    .CellFontName = "Wingdings"
    .CellFontSize = 20
    .CellAlignment = 3
    .Text = CStr(False) 'or CStr(True)
End With

To imitate RadioButton:

With MyFlex
    .Row = rowCount
    .Col = 2
    .CellFontName = "Wingdings"
    .CellFontSize = 20
    .CellAlignment = 3
    .Text = Chr(162) 'or Chr(164)
End With

MS FlexGrid Control[^]

Other resources:
http://www.xtremevbtalk.com/archive/index.php/t-131600.html[^]
http://vbcity.com/forums/t/158470.aspx[^]
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=40094&lngWId=1[^]
http://www.vb-helper.com/howto_checkgrid.html[^]
http://forums.codeguru.com/showthread.php?208733-Placing-a-Checkbox-in-a-FlexGrid-Cell[^]
http://www.vbforums.com/showthread.php?443526-RESOLVED-Flexgrid-Checkbox-Wingdings[^]

这篇关于如何在VBA（Excel）中的MSFlexGrid列上显示单选按钮的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！