Gurus,
I am attempting to change the caption of a checkbox based on a language selected. The translated words are on a separate worksheet (sheet1). The error I am receiving is
Run Time Error '24':
Object Required
I am not very familiar with VBA so I have no clue what that means. I only got this far by reading through threads on this forum.
TIA,
Please Login or Register to view this content.
Tim
This worked for me. The code will work in any area of userform module.
Please Login or Register to view this content.
Hello Tim,
My guess is that UserForm1 is not displayed when you run the macro. UserFrom1 must either be displayed or be loaded in memory. Otherwise you can not access it.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Have you checked the name of the checkbox?
If posting code please use code tags, see here.
Thanks Mehmetcik for pointing me in the right direction. For some reason your code did not work for me. However, I played around with it and after creating a Checkbox specifically for the language change I used the following code to change the captions of another checkbox. This code belongs on the worksheet under Microsoft Excel Objects. It is not a macro as I originally planned. Works great!!! Thanks again to all that replied.
Please Login or Register to view this content.
Eh, what happened to the userform of the thread title?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks