Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel Miscellaneous » Non English Excel » Problem between Excel english / french

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 08-13-2008, 03:20 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is becoming part of the community
Problem between Excel english / french

Please Register to Remove these Ads

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, 11:53 AM
arthurbr's Avatar
arthurbr arthurbr is offline
Non English Excel Moderator
  
Join Date: 23 Dec 2006
Location: Belgium
MS Office Version:XL2003
Posts: 2,887
arthurbr has an addiction to Excel
Hi Ritch and welcome to the board
Does the debugger give the line with the RC ref as the wrong one?
__________________

If you are pleased with a member's answer then use the Scales icon to rate it
Reply With Quote
  #3  
Old 08-15-2008, 12:25 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is becoming part of the community
Yes it highlight this line.
Reply With Quote
  #4  
Old 08-20-2008, 07:09 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is becoming part of the community
So anyone, any idea?
Reply With Quote
  #5  
Old 08-21-2008, 01:58 PM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
  
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,187
Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding
the OnAction property expects a macro name not a range

what exactly is the code trying to do?
__________________
Cheers
Andy
www.andypope.info
Reply With Quote
  #6  
Old 08-21-2008, 06:08 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is becoming part of the community
"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 06:11 PM.
Reply With Quote
  #7  
Old 08-22-2008, 04:23 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
  
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,187
Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding
I'm too young to know about Macro 4 things

Sorry I can help.
__________________
Cheers
Andy
www.andypope.info
Reply With Quote
  #8  
Old 08-22-2008, 10:06 AM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is becoming part of the community
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, 10:22 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
  
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,187
Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding
have you tried using a named range?

otherwise the only way I know is A1 notation.
__________________
Cheers
Andy
www.andypope.info
Reply With Quote
  #10  
Old 08-24-2008, 10:40 AM
martindwilson's Avatar
martindwilson martindwilson is offline
Forum Guru
  
Join Date: 23 Jun 2007
Location: London,England
MS Office Version:office 97 ,2003 ,2007
Posts: 6,017
martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding
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, 05:58 PM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is becoming part of the community
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, 08:22 PM
martindwilson's Avatar
martindwilson martindwilson is offline
Forum Guru
  
Join Date: 23 Jun 2007
Location: London,England
MS Office Version:office 97 ,2003 ,2007
Posts: 6,017
martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding
possibly, try it or maybe
OnAction = "MacroAutoComplete!Cells(1, 1).Cells(5, 1)"
Reply With Quote
  #13  
Old 08-29-2008, 11:45 AM
Cyberitch Cyberitch is offline
Registered User
  
Join Date: 13 Aug 2008
Location: Montreal
Posts: 7
Cyberitch is becoming part of the community
No luck, any other idea I could try?
Reply With Quote


Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

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

Contact Us - ExcelTip.com - Archive - Top