Listbox values can be viewed even "zoom in " in excel

[m_vishal_c]

hi , I have one list box in excel, when i click, it shows all values. when i zoom in, then i can not see list box values
Is there any way, if i zoom in still i can view all dropdown value from list box

Heaps thanks in advance

 

[m_vishal_c]

sorry, zoom out,

 

[My Aswer Is This]

I would not think this could be done. A listbox could have hundreds of values in it. How would you think you could see all the values in the listbox without scrolling down the listbox?

Now if you only have maybe 40 items in the listbox then maybe you could see them all if the listbox with tall enough. I assume you know you can make the listbox font size larger. In design mode right click listbox choose properties choose "Font" and change font size.

 

[Jaafar Tribak]

You would need to use a listbox like in a userform so it won't be affected by the worksheet zooming

 

[m_vishal_c]

You would need to use a listbox like in a userform so it won't be affected by the worksheet zooming

thanks Jaafar

 

[m_vishal_c]

I would not think this could be done. A listbox could have hundreds of values in it. How would you think you could see all the values in the listbox without scrolling down the listbox?

Now if you only have maybe 40 items in the listbox then maybe you could see them all if the listbox with tall enough. I assume you know you can make the listbox font size larger. In design mode right click listbox choose properties choose "Font" and change font size.

hi. thanks for replying. i have 1 list box in excel (not developer one), and some data reports which works on selection based on list box items. due to having huge report, i have to zoom out. so i can not see list box values. i hope you can understand my situation.
thanks

 

[My Aswer Is This]

So do you have things working OK now. Did you go with the plan in post 4? If not I'm not sure what you mean when you say not developer one. Then how did you make your listbox?

hi. thanks for replying. i have 1 list box in excel (not developer one), and some data reports which works on selection based on list box items. due to having huge report, i have to zoom out. so i can not see list box values. i hope you can understand my situation.
thanks

 

[m_vishal_c]

hi i go to DATAata Validation:- and List:- then i select value references like =$P$2:$P$12

 

[My Aswer Is This]

I see. It's a Data Validation list. Not a "listbox". Are you saying your having a hard time seeing the values in the data validation list? If so that is a problem others have complained about but there is no solution as far as I know using Excel 2013 or earlier. I'm not sure if they fixed this problem in Excel 2016 or not.

hi i go to DATAata Validation:- and List:- then i select value references like =$P$2:$P$12

 

[My Aswer Is This]

If your problem is your having a hard time seeing the values in a Data Validation list. There could be a Vba solution if you wanted. You would need a Activex listbox with your values and then a script entering the value from the listbox into the active cell.