View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default Pressing a CommandButton on a Userform via Code

I want to have a user click a Commandbutton on Userform5 that will Show
Userform8.
This is OK,
Userform8 has a CommandButton1 to View a Sheet in PrintPreview.
How can i get the Userform8 CommandButton to to Coded to Run to the Preview
with out having to press it ?


I tried:
Call Userform8.Commandbutton1 but get an error
also tried:

Call CommandButton1 but still get an error.

How can this be done?
Corey....