Help with buttons

Sadimy_Sam

New Member
Joined
Dec 22, 2005
Messages
1
I have a list of data. i would like to select a cell. eg. A1 and then press a button (which i know how to create) and then in that button sub routine it must remember the cell i clicked cos id like to manipulate and do things with that. ie. i would like some sort of button, even if it is a scroll down button that remebers or helps me a select a row in my spreadsheet which i can amnipulate
thanx
sam
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Cath

Board Regular
Joined
Aug 10, 2005
Messages
156
Hi

I don't quite understand exactly how you want to be reminded? You can easily have the code 'pick up' the cell address you clicked. And this information could be put in another cell, or shown in a message box? Its quite simple just decide where you want it.

Cath
 

Watch MrExcel Video

Forum statistics

Threads
1,118,373
Messages
5,571,768
Members
412,419
Latest member
acemali
Top