Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position of a drop-down list
Hi all,
I'm having some trouble with my drop-down list in excel. I've created a macro to update a list of valid entries (from somewhere else in my worksheet). And every time I update the list of valid entries, the drop-down list starts with the position at the bottom. So I'll have to scroll upwards to find my valid entries. How can I adjust my macro to make the starting position of scrollbar at the top of the drop-down list? (I've tried to record the action of opening the drop-down list and pulling the scroll to the top, but it won't record.) Thankful for any tips... Traima |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position of a drop-down list
Can you post your code ?
Daniel Hi all, I'm having some trouble with my drop-down list in excel. I've created a macro to update a list of valid entries (from somewhere else in my worksheet). And every time I update the list of valid entries, the drop-down list starts with the position at the bottom. So I'll have to scroll upwards to find my valid entries. How can I adjust my macro to make the starting position of scrollbar at the top of the drop-down list? (I've tried to record the action of opening the drop-down list and pulling the scroll to the top, but it won't record.) Thankful for any tips... Traima |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position of a drop-down list
When you click the drop down arrow in a cell with data validation, Excel
highlights the item in the list that matches the cell's contents, if possible. There's probably a blank cell at the bottom of your list of valid entries. If the cell with the data validation drop down is blank, Excel highlights that blank item, at the end of the drop down list. You could use a dynamic named range, to prevent blank cells in the valid items list. There are instructions he http://www.contextures.com/xlNames01.html Traima wrote: Hi all, I'm having some trouble with my drop-down list in excel. I've created a macro to update a list of valid entries (from somewhere else in my worksheet). And every time I update the list of valid entries, the drop-down list starts with the position at the bottom. So I'll have to scroll upwards to find my valid entries. How can I adjust my macro to make the starting position of scrollbar at the top of the drop-down list? (I've tried to record the action of opening the drop-down list and pulling the scroll to the top, but it won't record.) Thankful for any tips... Traima -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position of a drop-down list
Hi,
Thanks for both your tips. Debra - Yes, at this point, I'll have empty cells at the bottom of my input for the list. In the example in the instruction uses a fixed area of input of Ann Bert Carl Doris Ethel Fred Geoff Hans My list will have different numbers of names each time. Maybe only like this: Ann Doris Hans In the procedure of defining the name of the area, I need to define the lenght of the list - and that I won't know. Daniel - I haven't used much coding in this part of my worksheet. I'm using a fixed area of input in my list of valid entries, but I would like to know if there is a way to create a macro which opens the drop-down and sets the scrollbar at the top of the list. Thanks again, Traima "Debra Dalgleish" wrote: When you click the drop down arrow in a cell with data validation, Excel highlights the item in the list that matches the cell's contents, if possible. There's probably a blank cell at the bottom of your list of valid entries. If the cell with the data validation drop down is blank, Excel highlights that blank item, at the end of the drop down list. You could use a dynamic named range, to prevent blank cells in the valid items list. There are instructions he http://www.contextures.com/xlNames01.html Traima wrote: Hi all, I'm having some trouble with my drop-down list in excel. I've created a macro to update a list of valid entries (from somewhere else in my worksheet). And every time I update the list of valid entries, the drop-down list starts with the position at the bottom. So I'll have to scroll upwards to find my valid entries. How can I adjust my macro to make the starting position of scrollbar at the top of the drop-down list? (I've tried to record the action of opening the drop-down list and pulling the scroll to the top, but it won't record.) Thankful for any tips... Traima -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position of a drop-down list
Hi again,
Once I translated the formula in the name definiton field correctly into norwegian excel, your suggestion works out just fine, Debra! Thanks to both of you:) Traima "Traima" wrote: Hi, Thanks for both your tips. Debra - Yes, at this point, I'll have empty cells at the bottom of my input for the list. In the example in the instruction uses a fixed area of input of Ann Bert Carl Doris Ethel Fred Geoff Hans My list will have different numbers of names each time. Maybe only like this: Ann Doris Hans In the procedure of defining the name of the area, I need to define the lenght of the list - and that I won't know. Daniel - I haven't used much coding in this part of my worksheet. I'm using a fixed area of input in my list of valid entries, but I would like to know if there is a way to create a macro which opens the drop-down and sets the scrollbar at the top of the list. Thanks again, Traima "Debra Dalgleish" wrote: When you click the drop down arrow in a cell with data validation, Excel highlights the item in the list that matches the cell's contents, if possible. There's probably a blank cell at the bottom of your list of valid entries. If the cell with the data validation drop down is blank, Excel highlights that blank item, at the end of the drop down list. You could use a dynamic named range, to prevent blank cells in the valid items list. There are instructions he http://www.contextures.com/xlNames01.html Traima wrote: Hi all, I'm having some trouble with my drop-down list in excel. I've created a macro to update a list of valid entries (from somewhere else in my worksheet). And every time I update the list of valid entries, the drop-down list starts with the position at the bottom. So I'll have to scroll upwards to find my valid entries. How can I adjust my macro to make the starting position of scrollbar at the top of the drop-down list? (I've tried to record the action of opening the drop-down list and pulling the scroll to the top, but it won't record.) Thankful for any tips... Traima -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position of a drop-down list
You're welcome! Glad you were able to figure it out.
Traima wrote: Hi again, Once I translated the formula in the name definiton field correctly into norwegian excel, your suggestion works out just fine, Debra! Thanks to both of you:) Traima "Traima" wrote: Hi, Thanks for both your tips. Debra - Yes, at this point, I'll have empty cells at the bottom of my input for the list. In the example in the instruction uses a fixed area of input of Ann Bert Carl Doris Ethel Fred Geoff Hans My list will have different numbers of names each time. Maybe only like this: Ann Doris Hans In the procedure of defining the name of the area, I need to define the lenght of the list - and that I won't know. Daniel - I haven't used much coding in this part of my worksheet. I'm using a fixed area of input in my list of valid entries, but I would like to know if there is a way to create a macro which opens the drop-down and sets the scrollbar at the top of the list. Thanks again, Traima "Debra Dalgleish" wrote: When you click the drop down arrow in a cell with data validation, Excel highlights the item in the list that matches the cell's contents, if possible. There's probably a blank cell at the bottom of your list of valid entries. If the cell with the data validation drop down is blank, Excel highlights that blank item, at the end of the drop down list. You could use a dynamic named range, to prevent blank cells in the valid items list. There are instructions he http://www.contextures.com/xlNames01.html Traima wrote: Hi all, I'm having some trouble with my drop-down list in excel. I've created a macro to update a list of valid entries (from somewhere else in my worksheet). And every time I update the list of valid entries, the drop-down list starts with the position at the bottom. So I'll have to scroll upwards to find my valid entries. How can I adjust my macro to make the starting position of scrollbar at the top of the drop-down list? (I've tried to record the action of opening the drop-down list and pulling the scroll to the top, but it won't record.) Thankful for any tips... Traima -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Starting Position | Excel Worksheet Functions | |||
Drop box arrow position on cell | Excel Discussion (Misc queries) | |||
How do you find the position of the first value (< 0) in a list | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Tab list position in Excel | Excel Discussion (Misc queries) |