Automatic button after data entry

[excel199]

I have an input form in excel. What i cant figure out is how to automatically add a button to end of each row when i add the data. What i mean by that is that i have made this button with can be used to run a macro, i want that button to be copied and changed to run for this row each time i create a new row.

Example

I have Data from A3 to H3 and a button in I3 which when clicked cuts the A3 to H3 and moves to a different tab.

When i add data to A4 to H4 an automatic button should be created that would move data from A4 to H4 to a different tab when clicked.

I hope this is possible.

Thanks in advance.

[royUK]

Seems a strange way of working.Why are you moving the data?

[excel199]

Seems a strange way of working.Why are you moving the data?

Its like i am creating a excel file, so that i can move and create a pdf of all orders which are have enough inventory to be completed. so, if the order has enough inventory to be completed then it can be completed then i can click a button which would decrease my inventory and move the order to a permanent database while creating a delivery order.

I hope this helps... i am attaching my document which i am working on...

It would be great if you can look into it and give me suggestions on how to continue..

Thanks..

[excel199]

I have attached an excel 2007 file which you can check to understand what i am doing to comment on any other method you believe is better.


Thanks

[foxguy]

Hi excel199;

Here's 2 subs.
Create_Button() checks to see if there is already a button in the row, and if not creates one.

It assigns the "Button_Click" macro to the button.
Button_Click() determines what row it is on, so you can then call whatever macro you want with the row. That way you don't have to assign a different macro to each button.

Just put "Create_Button Target" into the Worksheet_Change() event wherever it's most useful to you.

Please Login or Register  to view this content.

[excel199]

Thanks... i think that is a good enough approach

[foxguy]

Be sure and mark the thread solved, and rate the answer if you liked it.

[excel199]

I can not figure out how to mark the thing solved.

[buran]

I can not figure out how to mark the thing solved.

It is described in the forum rules:

10. Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

:-)