[宝典]vb excel 单选框分组
vb excel 单选框分组
悬赏分:50 - 解决时间:2009-6-21 08:52
现在又遇到难题,就是关于单选框分组问题
代码如下:
'引用MS excel 11.0
Dim objExcel As Excel.Application
Dim objWorkBook As Excel.Workbook
Set objExcel = CreateObject("Excel.Application")
Set objWorkBook = objExcel.Workbooks.Add()
objExcel.Visible = True
'--------------设置活动工作
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
Dim objSheet As Excel.Worksheet
Set objSheet = objExcel.Worksheets("sheet1")
ActiveSheet.OLEObjects.Add(ClassType:="Forms.frame.1", Link:=False, DisplayAsIcon:=False, Left:=65, Top:=140, Width:=90, Height:=80).Select
ActiveSheet.OLEObjects("frame1").Object.Caption = "显示位置"
ActiveSheet.OLEObjects("frame1").Object.BackColor = vbWhite
ActiveSheet.OLEObjects.Add(ClassType:="Forms.optionbutton.1", Link:=False, DisplayAsIcon:=False, Left:=70, Top:=155, Width:=60, Height:=20).Select
ActiveSheet.OLEObjects("optionbutton1").Object.Caption = optguangshen.Caption
ActiveSheet.OLEObjects("optionbutton1").Object.Value = optguangshen.Value
ActiveSheet.OLEObjects("optionbutton1").Object.FontSize = 8
ActiveSheet.OLEObjects.Add(ClassType:="Forms.optionbutton.1", Link:=False, DisplayAsIcon:=False, Left:=70, Top:=175, Width:=60, Height:=20).Select
ActiveSheet.OLEObjects("optionbutton2").Object.Caption = optqinshui.Caption
ActiveSheet.OLEObjects("optionbutton2").Object.Value = optqinshui.Value
ActiveSheet.OLEObjects("optionbutton2").Object.FontSize = 8
'--------------------------------------------
ActiveSheet.OLEObjects.Add(ClassType:="Forms.frame.1", Link:=False, DisplayAsIcon:=False, Left:=155, Top:=140, Width:=90, Height:=80).Select
ActiveSheet.OLEObjects("frame2").Object.Caption = "显示方式"
ActiveSheet.OLEObjects("frame2").Object.BackColor = vbWhite
ActiveSheet.OLEObjects.Add(ClassType:="Forms.optionbutton.1", Link:=False, DisplayAsIcon:=False, Left:=70, Top:=195, Width:=60, Height:=20).Select
ActiveSheet.OLEObjects("optionbutton3").Object.Caption = opttong.Caption
ActiveSheet.OLEObjects("optionbutton3").Object.Value = opttong.Value
ActiveSheet.OLEObjects("optionbutton3").Object.FontSize = 8
ActiveSheet.OLEObjects.Add(ClassType:="Forms.optionbutton.1", Link:=False, DisplayAsIcon:=False, Left:=120, Top:=155, Width:=30, Height:=20).Select
ActiveSheet.OLEObjects("optionbutton4").Object.Caption = optwu1.Caption
ActiveSheet.OLEObjects("optionbutton4").Object.Value = optwu1.Value
ActiveSheet.OLEObjects("optionbutton4").Object.FontSize = 8
现在将上面的4个单选框分为两组,如何实现,急啊
问题补充:
用vb向excel添加两个frame,然后在两个frame上各添加两个option单选框,然后两两
分组
即两个单选框为一组,现在是四个单选框为一组,所以只能选一个,你看看图片是8个单
选框分一组,所以只能选一个单选框,我是想两个无的选项都被选中
提问者: fitgore - 五级
最佳
答案
八年级地理上册填图题岩土工程勘察试题省略号的作用及举例应急救援安全知识车间5s试题及答案
every radio button has a property of 'GroupName' in Excel macro.
设置第二组的groupname名称为同一名称,就OK了。
比如:
ActiveSheet.OLEObjects("optionbutton4").Object.GroupName = "SecondGroup"
是不是该给分了。
2
回答者: Juncox - 七级 2009-6-21 07:53