+ Reply to Thread
Results 1 to 5 of 5

Indent Cell Content automatically with vba (or new rule?)

  1. #1
    Registered User
    Join Date
    08-21-2018
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    24

    Question Indent Cell Content automatically with vba (or new rule?)

    Hi,

    on the left side is my table how it Looks like now and on the right side is my Goal.
    If the user writes in .column "Level" the Number in it should automatically be indended
    Thanks for the help.
    Attached Images Attached Images
    Last edited by JonasBig2; 08-22-2018 at 02:48 AM.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Indent Cell Content automatically with vba (or new rule?)

    Both look the same to me.

    Can you attach a workbook showing your sample.

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Registered User
    Join Date
    08-21-2018
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    24

    Re: Indent Cell Content automatically with vba (or new rule?)

    Changes have been done.

  4. #4
    Registered User
    Join Date
    07-26-2012
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    25

    Re: Indent Cell Content automatically with vba (or new rule?)

    I would suggest you to create and worksheet event, you can paste this code to specific worksheet vba:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-21-2018
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    24

    Re: Indent Cell Content automatically with vba (or new rule?)

    Thanks a lot pyrohac. It worked.

+ 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. Group WBS Rows Automatically Based on Indent Level (VBA)
    By rsfx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2024, 06:26 PM
  2. Replies: 7
    Last Post: 01-09-2016, 04:59 PM
  3. Automatically copy cells content based on the content of another cell.
    By chrisbarlow1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 11:13 AM
  4. [SOLVED] VBA referring to a different sheet, automatically fill cell based on content of other cell
    By mweick in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-06-2013, 11:50 AM
  5. Indent move cell, 2 indent move 2 cells etc
    By jomuir in forum Excel General
    Replies: 3
    Last Post: 05-14-2012, 11:56 AM
  6. automatically copy content into empty cell below
    By 4134x4nd3r in forum Excel General
    Replies: 5
    Last Post: 11-24-2011, 12:31 PM
  7. Automatically change text in cell based upon a rule
    By Beanymonster in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2009, 09:28 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