Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to create a macro that will add two checkboxes Yes "box here" No
"Box here", with a Macros for with the set with the "Yes" checked and a Macro with the set with the "No" checked, and so on to cover all the possible combinations. I have successfully, about 5 minutes ago made a Macro to add both boxes, but I could not change the boxes to have the check in them. I delved into the VB side of the Macro but do not know what the handler/switch/whatever it is called to indicate the box should be checked. Here is the VB: "Selection.TypeText Text:="YES " Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormCheckBox Selection.TypeText Text:=" NO " Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormCheckBox" Basically how do I change: "Type:=wdFieldFormCheckBox" to show the yes box checked? "Mike" wrote: Sure. Explain a little more though on what you're trying to do. "Steve COR" wrote: I have created a bunch of Macros for formatting and such. Can a Macro be made to enter text? Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Designing a spreadsheet - a brief guide | Excel Discussion (Misc queries) | |||
Designing a spreadsheet - a brief guide | New Users to Excel | |||
Designing a spreadsheet to track workflow | Excel Worksheet Functions | |||
Designing a Form | Excel Discussion (Misc queries) | |||
designing and linking | New Users to Excel |