ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Non English Excel
Problem between Excel english / french Problem between Excel english / french
Register FAQ Forum Rules Members List Calendar Search Today's Posts Mark Forums Read

Notices
Hi All,
The big green guy here, just wanted to let you all know that we now have the reputation system in place, the reputation system allows you to give a visible pat on the back to those that have helped you or whose information has been helpful.

You will see an icon in every post (Light Blue scales), click this to give the reputation point to whom you think deserves it, a green square appears for a reputation with more and more adding over time.Pretty soon you will see a string of green squares appear in the top right of your posts as your reputation grows and your forum presence!

Good Luck!
The Hulkster!

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 08-13-2008, 04:20 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is on a distinguished road
Problem between Excel english / french
This is probably a bug, but Im looking for a way to bypass the problem.

I dynamically (VBA) add dropdown list on top of some cells and set a call to a macro on the OnAction command like this:
Code:
With Worksheets("Page1")
    Set lb = .Shapes.AddFormControl(xlDropDown, Range("$G$2").Left, Range("$G$2").Top - 1, Range("$G$2").Width, 15.75)
    lb.ControlFormat.ListFillRange = "PagePara!$J$2:$J$4"
    lb.ControlFormat.LinkedCell = "$G$2"
    lb.OnAction = "MacroAutoComplete!R1C1:R5C1"
End With
When Excel is in english, no problem, when Excel is in french the OnAction give me an execution error '1004' the formula is to complicated to be affected to the object (translated from french...).

I suspect that in french the reference "MacroAutoComplete!R1C1:R5C1" is not possible. What should be the universal compatible way to set the reference?

Thanks.
~Ritch
Reply With Quote
  #2  
Old 08-14-2008, 12:53 PM
arthurbr's Avatar
arthurbr arthurbr is offline
Non English Excel Moderator
  
Join Date: 23 Dec 2006
Location: Belgium
Posts: 1,903
arthurbr will become famous soon enough arthurbr will become famous soon enough
Hi Ritch and welcome to the board
Does the debugger give the line with the RC ref as the wrong one?
__________________
Cheers

Here you can find the forum rules
Non English speaking forum
Relevant keyword thread title helps searching for info
Reply With Quote
  #3  
Old 08-15-2008, 01:25 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is on a distinguished road
Yes it highlight this line.
Reply With Quote
  #4  
Old 08-20-2008, 08:09 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is on a distinguished road
So anyone, any idea?
Reply With Quote
  #5  
Old 08-21-2008, 02:58 PM
Andy Pope's Avatar
Andy Pope Andy Pope is online now
Forum Moderator
  
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,162
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
the OnAction property expects a macro name not a range

what exactly is the code trying to do?
__________________
Cheers
Andy
Reply With Quote
  #6  
Old 08-21-2008, 07:08 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is on a distinguished road
"MacroAutoComplete" is a Macrosheet 4.0 and "R1C1:R5C1" is the row:column reference where are the macro command on the sheet.

And dont forget its wokring with english excel version, the problem occur only with french version.

So maybe there's another way to give the OnAction event the sheet!row:column reference?
Last edited by Cyberitch; 08-21-2008 at 07:11 PM.
Reply With Quote
  #7  
Old 08-22-2008, 05:23 AM
Andy Pope's Avatar
Andy Pope Andy Pope is online now
Forum Moderator
  
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,162
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
I'm too young to know about Macro 4 things

Sorry I can help.
__________________
Cheers
Andy
Reply With Quote
  #8  
Old 08-22-2008, 11:06 AM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is on a distinguished road
Quote:
Originally Posted by Andy Pope View Post
I'm too young to know about Macro 4 things

Sorry I can help.

Gosh now I feel old!!!

Its ok its very hard to find info about macro 4.0, and if you wanna know, its used for mobile device like pocket pc. Since you cant run (not yet) VBA on mobile device I use those old macro to do some automated actions.

Is there another way to reference a cell not using R1:C1 ?
Reply With Quote
  #9  
Old 08-22-2008, 11:22 AM
Andy Pope's Avatar
Andy Pope Andy Pope is online now
Forum Moderator
  
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,162
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
have you tried using a named range?

otherwise the only way I know is A1 notation.
__________________
Cheers
Andy
Reply With Quote
  #10  
Old 08-24-2008, 11:40 AM
martindwilson's Avatar
martindwilson martindwilson is offline
Valued Forum Contributor
  
Join Date: 23 Jun 2007
Location: London,England
Posts: 1,409
martindwilson is on a distinguished road
isnt french equivalent of R1C1 ..... L1C1
look in tools options general(what that is in french i have no idea)for where youd expect see the use r1c1 reference style
Reply With Quote
  #11  
Old 08-24-2008, 06:58 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is on a distinguished road
Quote:
Originally Posted by Andy Pope View Post
have you tried using a named range?
Named range?

Quote:
Originally Posted by martindwilson View Post
isnt french equivalent of R1C1 ..... L1C1
look in tools options general(what that is in french i have no idea)for where youd expect see the use r1c1 reference style
Yes in tools / options / general / ref style its L1C1 in french, whats that? You mean Excel expect L1 instead of R1?
Reply With Quote
  #12  
Old 08-24-2008, 09:22 PM
martindwilson's Avatar
martindwilson martindwilson is offline
Valued Forum Contributor
  
Join Date: 23 Jun 2007
Location: London,England
Posts: 1,409
martindwilson is on a distinguished road
possibly, try it or maybe
OnAction = "MacroAutoComplete!Cells(1, 1).Cells(5, 1)"
Reply With Quote
  #13  
Old 08-29-2008, 12:45 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is on a distinguished road
No luck, any other idea I could try?
Reply With Quote
Reply

Bookmarks

New topics in Non English Excel

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 12:53 PM.

Contact Us - ExcelTip.com - Archive - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0