Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Loss Focus
Hi Bill Li,
Use this statement: AppActivate (YourUserForm.Caption) HTH --- Orlando Magalhães Filho (So that you get best and rapid solution and all may benefit from the discussion, please reply within the newsgroup, not in email) "Bill Li" escreveu na mensagem ... Hello all, I am trying to build a macro to print out the barcode list. When people scan the barcode, the program will auto print out the whole list for this barcode. I have built the UserForm for inputing the barcode. However, after each printout, the UserForm losses the focus and I need use mouse to click the UserForm for the next input. If I remove the printout function, I can continue input barcode and no need to click the UserForm. Does anybody know how to active the UserForm after the printout? Thanks a lot! Best Regards Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Loss Focus
Hi HTH,
Great! It works! Thanks a lot! Best Regards Bill -----Original Message----- Hi Bill Li, Use this statement: AppActivate (YourUserForm.Caption) HTH --- Orlando Magalhães Filho (So that you get best and rapid solution and all may benefit from the discussion, please reply within the newsgroup, not in email) "Bill Li" escreveu na mensagem ... Hello all, I am trying to build a macro to print out the barcode list. When people scan the barcode, the program will auto out the whole list for this barcode. I have built the UserForm for inputing the barcode. However, after each printout, the UserForm losses the focus and I need use mouse to click the UserForm for the next input. If I remove the printout function, I can continue input barcode and no need to click the UserForm. Does anybody know how to active the UserForm after the printout? Thanks a lot! Best Regards Bill . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Loss Focus
Glad it worked.
Orlando Magalhães Filho "Bill Li" escreveu na mensagem ... Hi HTH, Great! It works! Thanks a lot! Best Regards Bill -----Original Message----- Hi Bill Li, Use this statement: AppActivate (YourUserForm.Caption) HTH --- Orlando Magalhães Filho (So that you get best and rapid solution and all may benefit from the discussion, please reply within the newsgroup, not in email) "Bill Li" escreveu na mensagem ... Hello all, I am trying to build a macro to print out the barcode list. When people scan the barcode, the program will auto out the whole list for this barcode. I have built the UserForm for inputing the barcode. However, after each printout, the UserForm losses the focus and I need use mouse to click the UserForm for the next input. If I remove the printout function, I can continue input barcode and no need to click the UserForm. Does anybody know how to active the UserForm after the printout? Thanks a lot! Best Regards Bill . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hardship letter explaining devastating loss property loss financi | Excel Discussion (Misc queries) | |||
Excel - Selected Cell highlight on focus loss. | Excel Discussion (Misc queries) | |||
focus | Excel Discussion (Misc queries) | |||
Weight loss line chart to monitor weight loss progress | Charts and Charting in Excel | |||
Must be a way to force focus back to sheet instead of UserForm - isn't there? | Excel Programming |