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 Chriss Miller 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
Joined
Jun 14, 2007
Messages
3
Location
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