Can a Command Button's position be kept moving along the TargetCell ROW in the same Column

Can a Command Button's position be kept moving along the Target Cell ROW in the same Column?

Dear Forum,

Is it possible to achieve the above as I need the Command Bitton Handy can it be moving in the same Column but let's say I am at the ROw 10 I need it to be next to it in the Column B

Warm REgards
e4excel

Hi Dgagnon,

Thnks for the help but I am not able to manage the Placement as I actually I require it almost at the same level as the selected Column B next to it...somewhere Column C..
But it does move which is important..

Hi Dave,

Nice Avatar..
Actually your code is absolutely wonderful, I mean I had hardly explained well this time and you produced a real gem..

I am inspired with this and was thinking of having two buttons enclosed in a small user form, is that possible too..

Application :
I am entering the Term Deposit information and sometimes some FD's are continued so I just would go in the selected cell and then I would hvae this Button Visible ( User Form ) Visible which has two buttons one Command Button would be to continue with the same Tenure and the other Command Button would be to continue with a new tenure...

WIll that be possible, unfortunately my file is not ready but is it ok this way as technically the the thread is SOLVED but I just realized that having two buttons would serve a better purpose...the user form containing these 3 Command Button needs to be moving..

Warm Regards
e4excel

Hi Dave,

I have created a File which has a User Form with 4 Command Buttons and I need the user Form to be visible on clicking inside the column exactly the same way you have already done except that this time it will be an User Form...

I also need help on the 4 Command Buttons, as you see this is Sheet which is used to record Fixed Deposit Entries..Usually the FD's are to be renewed incase we fail to submit the physical receipts on time, this is carried automatically by the bank which means that they just renew the F.D with the same details excpet that the Interest Rate changes subject to the prevailing interest rate..

1. Renew F.D. - What I need with this Button is to just copy the contents of the Target Cells CEll B ( Account Holder ), Cell C ( Bank Name ), Cell E (FDR Acct No), Cell F ( FDR No ), Cell G ( Int Rate ), Cell I ( Maturity Date ) and Cell K ( Maturity Amount ) and paste in the last row...
Most of the data would get pasted in the same columns i.e CEll B ( Account Holder ), Cell C ( Bank Name ), Cell E (FDR Acct No), Cell F ( FDR No ), Cell G ( Int Rate ) but some data changes its location as this FD is renewed so now the earlier Maturity Data becomes the opening Date and the New Maturity Date should be exactly the difference between the actual opening and Maturity Date so in this case it will be 182 days in my first example ....
Also, the Investing Amount would be the maturity Amount...
This FD is automatically created by the Bank and if you fail to report in 14 days and want to submit the Fd in your saving account then you lose the interest for those many days..

2. Continue F.D. - Same like above except that the Maturiy Date will be entered by the user manually as this FD is opened voluntarilly and not compulsorily

3. Delete Last Entry - Delete Last Row..

4. Delete Range : lets say the selected row is 8 and the data is filled till the 10 row then I need the deletion to take place from the row 8,9 and 10..

Please also advise on the formatting for the FOnt colour as well as the Borders to exist till the data is entered beginning from the column B..

WHat I meant is that can there be a formula in the row and then it gets copied to the value as I keep on getting the circular reference error

Bump No Response

Dear Dave,

It did work but it creates a circular reference as the entire cell gets copied alongwith the formula for the Maturity Amount which becomes the Principal AMount when the button is clicked..so can you please suggest a slight modification for that as well as how do I maintain the formatting in the columns since there are some columns which change places and therefore the formatting changes as the original while i need to maintain the same formatting like the column has..

It works and I agree to it and your help was indeed valuable as well as the links you provided are also very helpful...but I just need to better it..

Lets say i have data only till the 11th row i.e 10 records excluding the column headings so naturally my formulas in the columns A and the column K and COlumn L are also till the 11th Row..

Is there some method wherein I can have these formulas also get copied when I run the command button click..
I need help on these areas so that this work would be completely air-tight.

I want the Data Vaildation in the columns B and Columns C alongwith the Formula in the col A for Sr.No and the formula in the col K for the Maturity Amount as well as the Formula in the column L for the Interest to get written when the data gets copied to the last row..

I would appreciate if you could just help me with just 1 Data Validation and 1 Formula and I will take a cue from there.

Bottomline is I need help on some formatting and the Formulas..

Thanks in advance..

Warm Regars
e4excel

Ok No issues Dave,

I shall start a new thread but please do help me on that..

I will link this thread to the new one..

Warm REgards
e4excel
Thanks once again for your help Dave adn Dgagnon