+ Reply to Thread
Results 1 to 10 of 10

using cyrilic strings to vba excel

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    Serbia
    MS-Off Ver
    Excel 2003
    Posts
    24

    using cyrilic strings to vba excel

    I have a table with a column of text strings in the Cyrillic alphabet, ПO, НО, etc., and I need to make a comparison of this column with text strings again with cyrilic alphabet, and if this column value is the same with the column value with strings set value in the third column again values cyrilic string. When I type in cyrilic letters in the VBA editor, I get some symbols like أخ, دخ, etc. Is it possible to do this with a function or something?

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: using cyrilic strings to vba excel

    Upload a small representative sample excel workbook including the desired results (which you can enter manually) based on that sample data.

    Is it possible to do this with a function or something?
    It sounds like it would be possible to do this using Excel functions/formulas. I am confident that we can build one for you after seeing your sample and the desired results.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    Serbia
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: using cyrilic strings to vba excel

    my workbook is uploaded comparing columns 'Присутност' and 'Konacno' if columns values same insert ТАЧНО in column 'Unos'
    Attached Files Attached Files

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: using cyrilic strings to vba excel

    You forgot to put the desired results into your sample.

    I was expecting to see G2:G5 filled in manually.

    I'll take a look once you include the desired results into your sample.

    Also, consider updating your MS-Off Ver in your User CP. It is showing Excel 2003 but you uploaded a .xslx which indicates that you have at least 2007.

  5. #5
    Registered User
    Join Date
    08-17-2012
    Location
    Serbia
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: using cyrilic strings to vba excel

    i changed my sample, and i filled all my columns
    Attached Files Attached Files

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: using cyrilic strings to vba excel

    Try this in F2 of the sample from post #5:

    =IF(COUNTIF(J:J,E2),"Тачно","Нетачно")

  7. #7
    Registered User
    Join Date
    08-17-2012
    Location
    Serbia
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: using cyrilic strings to vba excel

    thanks for your respond

  8. #8
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: using cyrilic strings to vba excel

    You're welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  9. #9
    Registered User
    Join Date
    08-17-2012
    Location
    Serbia
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: using cyrilic strings to vba excel

    sorry, i have one more question in connection with display serbian cyrillic in message box. my sheet have column that contains values serbian cyrillic, how display those values in msgbox?

  10. #10
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: using cyrilic strings to vba excel

    This is a new unrelated question and thus should get a new thread.

    Go ahead and start a new thread showing a small representative sample of your data along with the desired result.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to Delete only Alpha Strings but not Alphanumeric or Numeric Strings in a Cell
    By papageorgio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2016, 06:55 AM
  2. Moved to commercial services forum.
    By Midnight-Oil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2015, 01:05 PM
  3. excel formula to search Multiple strings in several columns and return strings
    By krratna123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2013, 11:20 AM
  4. Replies: 1
    Last Post: 08-13-2013, 08:32 AM
  5. Replies: 5
    Last Post: 02-15-2012, 09:57 AM
  6. Replies: 3
    Last Post: 07-30-2008, 11:46 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1