View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mecg96 mecg96 is offline
external usenet poster
 
Posts: 4
Default Interacting with Forms

I have a program that is installed as an excel addin and I want to automate
some processes I do with this program. I am using this code to open a form
where I need to change some options before performing another operation:

Set C = CommandBars("Worksheet Menu
Bar").Controls("MyToo&ls").Controls("&Template Options")
C.Execute

This successfully calls the form, but I don't know how to change the options
in the form. Is there a way to do this?

Thanks!