How To Add In Line Row Controls In an Excel table

In this week’s training, I will show you how to add In-Line Row Control buttons.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 - Introduction
0:23 - Overview
2:32 - Selection Change Event
5:47 - Display Buttons
8:03 - Hide Buttons
8:26 - Delete Row
10:18 - Move Buttons
11:28 - Insert Row Above
12:56 - Copy Down

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #inlinerows #inlinerowcontrols #addinginlinerowcontrols

[dawn.henderson]

Randy, this is awesome. Many years ago I developed an application that requires an audit trail of user actions such as row deletions, and all worksheet change events. It took a few days to complete and was not at all pretty. This elegant but simple solution is perfect for upgrading my application.

[francoismarsau]

As always great material.Returned to this video after many months realising I now need this for and app. For some reason I cant seem to download the workbook using the email link provided. Am I doing something wrong?

[alezander]

Thank you so much, great video, it realy help me a lot. I have only one question: How can i modify the code below to display the button in the cell that I select and not to be displayed only in A colom
With .Shapes("deschide1")
.Visible = msoCTrue
.Left = ActiveSheet.Range("A" & ActiveCell.Row).Offset(0, 0).Left
.Top = ActiveSheet.Range("A" & ActiveCell.Row).Offset(0, 0).Top
.IncrementLeft -0
End With

[radonnabelk]

If I am on the first row, under the header (E4) and click Insert Row, it adds another header formatted row, instead of a table formatted row. Also, is there a way to copy the formulas from the selected row to the new row above?
Thank you for your very helpful videos. They have helped me create some very useful spreadsheets for my office.

[poisonzero]

This is really nice!
When filtering the data (hiding rows), the CopyDown button gets lost. Is there any way I can solve this?

[sircorn]

Hi, Thank you for this videos. This one is on my desk top.
Is there a one-macro way to copy(cut) a line not just below it, but in a different location chosen by a click, a few rows above or below? I do it using two macros: one to cut and one to insert. Thank you.

[philipmcdonnell]

Hi Randy, thanks for the video. I’m just wondering how the trigger for the conditional formatting gets copied down when you use the insert button?

[SphincterOfDoom]

Where are you defining these buttons where .Shapes maps to them?

[titofouente]

Thanks Randy for the video, I format the data as a table and the copy down button doesn't work. Is it possible to do it?

[GinaBee-gr]

How will the CopyDown() work in a table?

[dmgilbertson_]

Hi Randy. One feature I'd like to add to my version is to have a small display test box appear when the mouse hovers over the Delete Button, for example, that simply says "Delete Row", then disappears when the mouse is not hovered over the button. Is there a quick solution? This would be for any other users that may use my worksheet.

[AniManuSCh]

wow awesome, this is really nice, hey! how about a button to protect the row with password, something like a user who logs his checking data registry and before go let it protected?
I had been working on an extensive excel project file for media production like animation, and that is one of the few features left I still struggling about, along side with add new months to a gantt and make a comparison between expected start vs actual start and make a both sides direction working cells to enter and reflect data one each other like from page ACTAs to page Bitácora but if other user wants to do it oposite way (from Bitácora to ACTAs) it should work too and even with more than just 2 pages, cells or whatever, example: you put data on A1 and A2 reflect it (=A1) but as I want it to work both ways, which means that also at any time you should be able to put the data on A2 and A1 also should reflect it, so I think is something only with VBA can be done., the point is that you can put data on any given cell whenever you want and the other or others should reflect it.
Can you help please?

[garyallan]

Love it. Over the years I have dealt with a lot of (shall we say) stupid users who do things that I would never think of. As you say in your video, if a user deletes a row (manually), then he or she will also delete the buttons. How do you prevent this?

[Mn.Pp.]

How do I modify the code for insert row, to insert it instead above, to insert the row below?