Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Dropdown box Jumpup
I have a dropdox box at the bottom of a very large userform that takes up my
whole screen. When I engage the drop down box, the menu disappears below my screen. Is there a property I can change in the properties window which will give me the option of have the menue jump up insteda of drop down. I want to be able to see the options. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Dropdown box Jumpup
Hi ExcelMonkey,
Is there a property I can change in the properties window which will give me the option of have the menue jump up insteda of drop down. Not to my knowledge. Why not change the ListRows property to (say) 1. The user can then scroll though the list. --- Regards, Norman "ExcelMonkey" wrote in message ... I have a dropdox box at the bottom of a very large userform that takes up my whole screen. When I engage the drop down box, the menu disappears below my screen. Is there a property I can change in the properties window which will give me the option of have the menue jump up insteda of drop down. I want to be able to see the options. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Dropdown box Jumpup
In XL2003 a combobox(on my testing) automatically "jumps up" if they are at
the bottom of the (full screen) userform. "ExcelMonkey" wrote: I have a dropdox box at the bottom of a very large userform that takes up my whole screen. When I engage the drop down box, the menu disappears below my screen. Is there a property I can change in the properties window which will give me the option of have the menue jump up insteda of drop down. I want to be able to see the options. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Dropdown box Jumpup
Hi Toppers,
In XL2003 a combobox(on my testing) automatically "jumps up" if they are at the bottom of the (full screen) userform. For me too - on checking! --- Regards, Norman "Toppers" wrote in message ... In XL2003 a combobox(on my testing) automatically "jumps up" if they are at the bottom of the (full screen) userform. "ExcelMonkey" wrote: I have a dropdox box at the bottom of a very large userform that takes up my whole screen. When I engage the drop down box, the menu disappears below my screen. Is there a property I can change in the properties window which will give me the option of have the menue jump up insteda of drop down. I want to be able to see the options. Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Dropdown box Jumpup
Perhaps you could use the DropButtonClick event procedure to change the
position (i.e., the .Top) of the combobox - this would have the effect of making it "jump up." Basic code (set TopHigh and TopLow according to your needs): Private Sub ComboBox1_DropButtonClick() Static CBJump As Boolean CBJump = Not (CBJump) If CBJump Then ComboBox1.Top = TopHigh Else ComboBox1.Top = TopLow End Sub -- - K Dales "ExcelMonkey" wrote: I have a dropdox box at the bottom of a very large userform that takes up my whole screen. When I engage the drop down box, the menu disappears below my screen. Is there a property I can change in the properties window which will give me the option of have the menue jump up insteda of drop down. I want to be able to see the options. Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make Dropdown box Jumpup
Thanks. Yeah I am in XL2000.
"K Dales" wrote: Perhaps you could use the DropButtonClick event procedure to change the position (i.e., the .Top) of the combobox - this would have the effect of making it "jump up." Basic code (set TopHigh and TopLow according to your needs): Private Sub ComboBox1_DropButtonClick() Static CBJump As Boolean CBJump = Not (CBJump) If CBJump Then ComboBox1.Top = TopHigh Else ComboBox1.Top = TopLow End Sub -- - K Dales "ExcelMonkey" wrote: I have a dropdox box at the bottom of a very large userform that takes up my whole screen. When I engage the drop down box, the menu disappears below my screen. Is there a property I can change in the properties window which will give me the option of have the menue jump up insteda of drop down. I want to be able to see the options. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make input in one column determine dropdown list in another. | Excel Discussion (Misc queries) | |||
make pivottable dropdown work like the filter. | Excel Programming | |||
How to make a dropdown look up box | Excel Programming | |||
How can I allow users to make multiple selections from a dropdown. | Excel Worksheet Functions | |||
how to make dropdown arrow disappear in vba | Excel Worksheet Functions |