column value

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

I'd like to retrieve a columns value to add to a string in
a macro I'm creating.

At the top of each column I have a button, and I want to
get the current column value (e.g. A, B or C) into the
string I'm using to reference the cell locations I'm
attempting to update.

Is there anyway to get the current column value (text
format), based on the location of the button ?

Much appreciated for any help you can give me to get me in
the right direction.

Cheers

mark
 
You might get it by using the Top/Left properties of Button and Cell,
but why not just code a number into the button_click event ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - Run same logic on values in columns 2 & 3 0
Simple Macro 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Weighted randbetween text list 3
Data Validation List (conditional) 2
Transfer array element offset value to a matched value 3
Find a value in a sheet and replace it with another value if it matches 8
Match Values and Copy Rows 3

Back
Top