+ Reply to Thread
Results 1 to 4 of 4

column E text align to right if text in column C is "T"

  1. 05-25-2018, 07:59 AM #1
    hktom
    hktom is offline
    Registered User
    Join Date
    02-23-2015
    Location
    hk
    MS-Off Ver
    window7
    Posts
    240

    column E text align to right if text in column C is "T"

    Hi

    If the column c is T, then vba code make the column E text aligh to right
    Sheet 1 is question and after vba code , the answer is as “answer”sheet attached

    The attached VBA code is not work. Please help

    Thanks
    Tom
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-25-2018, 08:21 AM #2
    MarMo
    MarMo is offline
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365 - version 2310
    Posts
    278

    Re: column E text aligh to right if text in column C is "T"

    Hi Tom,

    See attached file with your modified code.

    Hope this is helpfull.
    Krgds,
    Mario
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 05-25-2018, 08:26 AM #3
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: column E text aligh to right if text in column C is "T"

    Hi Tom,

    Give this a try:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  4. 05-25-2018, 09:36 AM #4
    hktom
    hktom is offline
    Registered User
    Join Date
    02-23-2015
    Location
    hk
    MS-Off Ver
    window7
    Posts
    240

    Re: column E text aligh to right if text in column C is "T"

    The problems solved. Thanks for all of your help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to Copy and Paste Specific Text in Column A on the last line with Text in Column B?
    By D2S in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2017, 04:08 PM
  2. [SOLVED] VBA Macro to find text string in one column and replace specific text in another column if
    By bmahfood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2017, 11:15 AM
  3. VBA excel to word insert footer (Text - Left align) & (Page number - Right align)
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2017, 06:22 PM
  4. Filter column by text, then export column to new workbook, replace searched text with new.
    By Headhunter234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2015, 07:48 AM
  5. [SOLVED] Format align text in column when export to excel with VBA
    By Cuong Pham in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2013, 12:11 AM
  6. Align text box to a column
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2010, 08:18 AM
  7. [SOLVED] Set the text align property of each individual column on UserForm1.ListBox1.ColumnCount = 5
    By Drom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2005, 05:21 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1