Thread: Macro Designing
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Steve COR Steve COR is offline
external usenet poster
 
Posts: 13
Default Macro Designing

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