View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryan ryan is offline
external usenet poster
 
Posts: 4
Default Userform.Show after sendkeys

I have tried alot of different things including sending this code to
another module after running sendkeys to show my userform with no
success. the simple code below sends paper select commands to a
printer and then shows a userform. for some reason the userform does
not ever show and the code goes bad. do i need to cap off the sendkeys
command before executing more code? what can i do to show a userform
after sendkeys? thanks for your help

Sub print_fast()

SendKeys "^{p}"
SendKeys "%{m}"
SendKeys "HP DesignJet"
SendKeys "%{r}"
SendKeys "{esc}"
SendKeys "{esc}"

PLU_SCREEN.Show

End Sub