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

**JonasBig2** · 08-22-2018, 02:37 AM

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.

**kersplash** · 08-22-2018, 02:38 AM

Both look the same to me.

Can you attach a workbook showing your sample.

Go Advanced -> Manage Attachments -> Upload

**JonasBig2** · 08-22-2018, 03:02 AM

Changes have been done.

**pyrohac** · 08-22-2018, 03:47 AM

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.

**JonasBig2** · 08-23-2018, 03:06 AM

Thanks a lot pyrohac. It worked.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Group WBS Rows Automatically Based on Indent Level (VBA)

Hello, how to distribute content to a cell by various cells automatically.

Automatically copy cells content based on the content of another cell.

[SOLVED] VBA referring to a different sheet, automatically fill cell based on content of other cell

Indent move cell, 2 indent move 2 cells etc

automatically copy content into empty cell below

Automatically change text in cell based upon a rule

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions