Home |
Search |
Today's Posts |
#1
|
|||
|
|||
drop down box to open when selected
Help please excel; when I select a cell that has a drop down box I want it to
open |
#2
|
|||
|
|||
Look here at Debra Dalgleish's web page on the subject:
http://www.contextures.com/xlDataVal01.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Tammy" wrote in message ... Help please excel; when I select a cell that has a drop down box I want it to open |
#3
|
|||
|
|||
Help please excel; when I select a cell that has a drop down box I want it
to open Try some code in the worksheet module (rightclick the sheet tab & "View Code"): Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address < "$B$2" Then Exit Sub SendKeys "%{DOWN}" End Sub |
#4
|
|||
|
|||
I tryied this but it did not work I'm sure I've done something wrong. I
pasted the formula in visual basic and saved would that be it? Help Please "Andy Brown" wrote: Help please excel; when I select a cell that has a drop down box I want it to open Try some code in the worksheet module (rightclick the sheet tab & "View Code"): Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address < "$B$2" Then Exit Sub SendKeys "%{DOWN}" End Sub |
#5
|
|||
|
|||
I tried this but it did not work I'm sure I've done something wrong. I
pasted the formula in visual basic and saved would that be it? Help Please It works for cell B2, and assumes that B2 has some Data Validation attached to it, and must go in the worksheet module (*not* an ordinary one). For info on worksheet events, see http://www.mvps.org/dmcritchie/excel/event.htm ; for info on DV, start at http://www.contextures.com/xlDataVal01.html Rgds, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
Filling drop down box | Excel Discussion (Misc queries) | |||
drop down help | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |