Have a look here : <http://msdn.microsoft.com/en-us/library/aa196237(office.11).aspx> http://msdn.microsoft.com/en-us/library/aa196237(office.11).aspx
Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de ??????????????? Envoyé : samedi 20 novembre 2010 12:48 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ how to change language automatically I have user form contains textbox I'm using this code to pres "ALT+SHIFT" to change language automatically to other language(Arabic) Me.TextBox1.SetFocus Application.SendKeys ("%+") And it is working good But if excel language is Arabic This code change it to English Is there a way to know the excel language before running the form ? thanks -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall <http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > &ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts