VB for Applications
 

Hi,
What I want is to be able to select a cell and the number in that cell
inserted into another cell on a different sheet in the same workbook and then
jump to that worksheet. I could use a commandbutton on the row that I want
the number from, but the trouble starts when I use autofilter to select a
selection of the data, the buttons remain where they are and therefore
reference the worng data cell.

All help apreciated.

VB for Applications
 

hi
command buttons (and all other controls) "float" on top of the sheet. they
cannot be attatch to or put in rows, columns or cells. that is why they stay
where they are when you autofilter.
you will have to come up with a different approach.
perhaps put the button in the upper left corner of the sheet (a1) and freeze
panes on row 1. then recode so that you click on the cell you want copied
then click the button and have the contents of the activecell inserted into
another cell on a different sheet.
there are different ways to do it. this is just one.

regards
FSt1

"Graham" wrote:

Hi,
What I want is to be able to select a cell and the number in that cell
inserted into another cell on a different sheet in the same workbook and then
jump to that worksheet. I could use a commandbutton on the row that I want
the number from, but the trouble starts when I use autofilter to select a
selection of the data, the buttons remain where they are and therefore
reference the worng data cell.

All help apreciated.

VB for Applications
 

Hi Thanks for that.
Do you have ant idea of the code to copy the data in the active cell and
insert it into the other sheet?

Graham

"FSt1" wrote:

hi
command buttons (and all other controls) "float" on top of the sheet. they
cannot be attatch to or put in rows, columns or cells. that is why they stay
where they are when you autofilter.
you will have to come up with a different approach.
perhaps put the button in the upper left corner of the sheet (a1) and freeze
panes on row 1. then recode so that you click on the cell you want copied
then click the button and have the contents of the activecell inserted into
another cell on a different sheet.
there are different ways to do it. this is just one.

regards
FSt1

"Graham" wrote:

Hi,
What I want is to be able to select a cell and the number in that cell
inserted into another cell on a different sheet in the same workbook and then
jump to that worksheet. I could use a commandbutton on the row that I want
the number from, but the trouble starts when I use autofilter to select a
selection of the data, the buttons remain where they are and therefore
reference the worng data cell.

All help apreciated.