Excel Recording a macro

[BobbyMaynard]

Ok guys i know the short cut for starting and stopping a recording macro is Alt+T+M+R. My problem is im wanting a macro that will insert a new Row in my table, in form view. (Select anywhere on the table, click on insert at the top ribbon, then click on "Form" on the top right ribbion, then click on "NEW". That is where i need the recording to stop. At that point the shortcut for stopping the recording does not work. I know where there is a will there is away. Im guessing this will have to be hard coded in VBA but i have no idea how to do that. Can someone please help me?

 

[Fluff]

Once the Form is loaded you cannot stop the macro and I don't think the recorder can "see" what you do in the form anyway.

 

[BobbyMaynard]

Ok, i do have another idea. I can do a macro to insert new row at bottom of table, then fill in the information on the table view instead of form view. But that brings another question to mind. As this worksheet grows, how do i make it always go to the bottom row instead of Say row 123 at the time the macro was recorded? Thank you for your patience as i am just learning the more advanced features of excel. I will try to find a website to host my screen shot so i can attach it to this thread. Or is there away to upload an image here?

 

[Fluff]

Depends on what you are trying to do, but if you are using the in-built form it will automatically add the new row at the bottom of the table, so no need for a macro.

 

[BobbyMaynard]

If you can PM me your email address I will send you a screen shot of what im doing. I think once you see it, it will make more sense

 

[Fluff]

Firstly, I have no intention of giving my email address to a complete stranger.
Secondly, all communication must remain on the board as per forum rules.

If you want to supply an image you will need to upload it to a website & post the link here.
But if you want help you would be better explaining what you are trying to do.
In you op you said you were using the in-built data form, but then seemingly totally ignored what I said in post#4.

 

[BobbyMaynard]

wow.... forget i asked... in fact if all MODerators are that arrogant then I do not want your help. All you had to say was it was against website rules or what ever.

 

[Fluff]

I'm sorry if you think that what I posted was rude or arrogant, it certainly wasn't meant that way and I apologise for any offence taken.

I am more than happy to help, but I will require more information about what you are trying to do.