Drop down lists show button?

C

coal_miner

Greetings. First off, let me thank anyone in advance for taking the time to
assist me. My question should be easy to answer. I have setup some drop
down lists in one of my worksheets. The button with the arrow that opens the
list hides itself after I click on another cell. How can I keep that button
always showing? Thanks again. Cheers.
 
D

Debra Dalgleish

Only the active cell can have the data validation arrow visible.
Perhaps you could colour the cells to highlight them, or add comments to
the cells to mark them.
 
C

coal_miner

Thank you for your help Debra.

Debra Dalgleish said:
Only the active cell can have the data validation arrow visible.
Perhaps you could colour the cells to highlight them, or add comments to
the cells to mark them.
Click to expand...
 
×

מיכ×ל (מיקי) ×בידן

Hi, coal_miner,
I would suggest as follows:
*** assume the 'Drop Down List' is in Cell I10.
1. Catch a 'print-screen' of the small arrow button.
2. Paste ithe exactly over the original 'drop-down list' button.
3. Write a short Macro:
=============
Sub Show_Drop_Down_I10()
[I10].Select
SendKeys "%{down}" ' emulates Alt+Down Arrow
End Sub
=======
Allocate that Mcro to the Picture.
*** Click on the Picture and..... voilà !
Michael Avidan - ISRAEL
http://forums.tapuz.co.il/office
 
C

coal_miner

Thank you

מיכ×ל (מיקי) ×בידן said:
Hi, coal_miner,
I would suggest as follows:
*** assume the 'Drop Down List' is in Cell I10.
1. Catch a 'print-screen' of the small arrow button.
2. Paste ithe exactly over the original 'drop-down list' button.
3. Write a short Macro:
=============
Sub Show_Drop_Down_I10()
[I10].Select
SendKeys "%{down}" ' emulates Alt+Down Arrow
End Sub
=======
Allocate that Mcro to the Picture.
*** Click on the Picture and..... voilà !
Michael Avidan - ISRAEL
http://forums.tapuz.co.il/office


coal_miner said:
Thank you for your help Debra.
Click to expand...
Click to expand...
 
L

Leon Sapper

Hi, This is my first try in a Discussion Group, so bear with me.

I have a range of cells, (C4:M26) in which I wish to put a staff members
initials into indervidual cells. The rows are different jobs and the coloums
are the dates of the month. I have a list of staff initials in coloum A
(A4:A30).

Every time I try to make a list, I get a error message..."A list can not
overlap another list" and I can go no further.

Kind regards,
 
P

Paul B

Leon, you could use Data Validation for the drop down list, have a look here
for more information

http://www.contextures.com/xlDataVal01.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
O

Otto Moehrbach

You didn't say what part (range) of your data you wanted to put into the
list for the drop-down cell. If you want A4:A30, name that range say,
TheList. Then go to the cell in which you want to put the drop-down and
click on Data - Validation. Select List. In the Source block type
"TheList" without the quotes. That's it. HTH Otto
 
D

Debra Dalgleish

You can use the Fill Color button on the Formatting toolbar, to format
the cells.
 
D

Debra Dalgleish

To quickly select all the cells that contain data validation, so you can
format them:

Click the Select All button at the top left of the worksheet, or select
a single cell on the worksheet.
Choose Edit>Go To, and click the Special button
Select Data Validation, All, and click OK
 
A

alec

thanks paul, that fixed that. but now that i'm on the make, if I have my list
with different colour pattens, can I have the cell colour patten transferred
also?? how?
 
Top