Excel VBA To change the Cell reference by clicking Button

[Ashar Ilyas]

Hi all,

I am unable to change the cell reference by clicking the button (VBA ENABLED BUTTON).
for instance: 1- Cell reference is "A2" and after clicking the button the cell reference will automatically "A3" and so on till the blank cell
2- Up and downside both buttons are available to work.

Thank you.

 

[Ashar Ilyas]

Mean selecting down cell by just clicking Button

Please any expert here. I need Help

 

[My Aswer Is This]

Mean selecting down cell by just clicking Button

Please any expert here. I need Help

I do not believe that is possible.
You want the button to keep a history of what was previous done
A scroll Bar can do that. What is your overall objective

 

[My Aswer Is This]

Now if you want to enter some data in next empty cell we can do that.

 

[Ashar Ilyas]

I do not believe that is possible.
You want the button to keep a history of what was previous done
A scroll Bar can do that. What is your overall objective

Demo sheet.xlsm
	Q
14
Main Sheet

Actually i have to save specific infoamtion in PDF in specific formates.

Currently i am doing to copy only one Cell (Customer ID) from raw data and paste it into a specific cell of another sheet. Rest formulas do the job

So i need a automation to select down cell instead of shifting sheets and copying data

Thankyou

 

[Ashar Ilyas]

Any Expert ???? Please