Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inheritance module
I've a the same form in Dutch and in French. There is an Access
database with all the users with their language preference. How can I depending on the language of the person call a form in Dutch OR French. Don't won't to program 2 times the form but do it with a module or something like that. Any help is welcome. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
inheritance module
Does this work for you?
If you are willing to create a copy of your UserForm and Rename the forms: Then Create two UserForms named: UserFormDutch UserFormFrench Assuming you are able to query the db and get the language for the User, assign the Language to a Public variable, say Lang. Then Sub OpenUserForm() UserForm & Lang.Show End Sub "@ndy" wrote: I've a the same form in Dutch and in French. There is an Access database with all the users with their language preference. How can I depending on the language of the person call a form in Dutch OR French. Don't won't to program 2 times the form but do it with a module or something like that. Any help is welcome. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Inheritance of references | Excel Programming | |||
arrays - module to module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |