Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing menus

Status
Not open for further replies.

rallowiz

Programmer
Jun 14, 2007
3
CA
I am actually working with excel and not with access but my question is a vba one so I hope that it won't matter.
What I need is the vba code to access the build in userforms. For example, file--> pagesetup, a pagesetup form will appear, I want to be able to select the controls within that pagesetup form and change their values or use their onAction methods. Can someone help me?
 
Alt + F11 will bring up the VBA editor and then "Insert" + "User Form
 
Sorry, read it wrong. I thought you wanted to create a new form.
 
I took that direction before but it only helped me to get the userform to pop up, I need to be able to control it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top