Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!

Without seeing it we are a bit in the dark, but it sounds like a simple
Control toolbox control that is only made visible when the header is
selected and the click event of that control does the rest.

Look at the worksheet code module for that sheet and see if there is code in
there.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"davegb" wrote in message
ups.com...
Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!

Sounds like a Data Validation cell with some event code that responds to the
selection made. For Data validation, see:

http://www.contextures.com/xlDataVal01.html
--
Gary''s Student - gsnu200723


"davegb" wrote:

Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!

If you go to the VBE, double click the sheet that this is on... you should be
able to see the Code he is using. If you post the code, it will be much
easier to figure out what he does. But most likely it is an event that
triggers a macro that uses a relative reference to show the button and the
menu. Then when you click on the options, it is probably Linked to either
another cell or macro that changes the header. Or he could be completely out
of my league in XL also and is doing something that is a lot more
complicated.

"davegb" wrote:

Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!

Code may be a possibility, but
It sounds like data validation under the data menu using the list option.
the remainder of the changes could be done with formulas.

If you don't see the formulas, then perhaps those cells are locked and the
formulas hidden.

--
Regards,
Tom Ogilvy



"davegb" wrote:

Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!

Code may be a possibility, but
It sounds like data validation under the data menu using the list option.
the remainder of the changes could be done with formulas.

If you don't see the formulas, then perhaps those cells are locked and the
formulas hidden.

--
Regards,
Tom Ogilvy


"davegb" wrote:

Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!

On May 22, 12:25 pm, Tom Ogilvy
wrote:
Code may be a possibility, but
It sounds like data validation under the data menu using the list option.
the remainder of the changes could be done with formulas.

If you don't see the formulas, then perhaps those cells are locked and the
formulas hidden.

--
Regards,
Tom Ogilvy



"davegb" wrote:
Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!- Hide quoted text -

- Show quoted text -

Thanks for the replies. I should have mentioned in my first post, that
there is no code anywhere I know to look for it. No modules, and no
code behind any of the sheets. I thought at first it was probably an
event driven macro.

It's data validation, which I've heard of but never seen used. Thanks
for letting me know. Now I guess, when I have some time, I've got to
go look that up and see how it works!