LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Direction problem in inserting strings using right to left language

Hi!

I'm trying to use InsertAfter to add string in a right to left language, and
right after it space and number.

The problem is that logically, Word adds the characters in the correct way
(Right to Left Text - Space - Number),
But in my view it looks like: (Right to Left Text - Number - Space).

I'm using something like:
Selection.InsertAfter "From: " ' "From" is replaced by a word in right to
left language)
Selection.InsertAfter " " & strMyString 'strMyString contains a string which
is actually a number, e.g. "1234"

problem is solved if I type the space manually, but I don't know how to
force VBA to write a "Right To Left" direction when it inserts the space
between the strings.

How can I force VBA to insert the space string in a Right to Left direction,
so that it will 'look' like it's between the two other strings and not just
logically "be" there?

Regards,
Amir.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I change worksheet direction from right to left Haitham New Users to Excel 2 March 6th 10 08:28 PM
Change worksheet direction from right to left CheekyB Setting up and Configuration of Excel 3 November 27th 08 03:53 PM
Make left-to-right default direction hmm Excel Discussion (Misc queries) 1 March 18th 08 03:37 PM
i`d like to change the direction of office 2007 to left to right ahmed ramadan New Users to Excel 8 November 2nd 07 01:14 PM
Right-to-Left direction Ninad Excel Worksheet Functions 2 July 20th 07 07:35 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"