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]

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.

hi thanks for replying. I tried from different ways but cant get it. can you please provide script . thanks

 

[My Aswer Is This]

I asked this question and you did not say yes or No.
"Are you saying your having a hard time seeing the values in the data validation list?"
If so are you willing to use Vba?
Are you familiar with using Vba?

Now what column of data do you want in your listbox?
And if you click on ""George" in the listbox where do you want the value to be entered?

 

[m_vishal_c]

I asked this question and you did not say yes or No.
"Are you saying your having a hard time seeing the values in the data validation list?"
If so are you willing to use Vba?
Are you familiar with using Vba?

Now what column of data do you want in your listbox?
And if you click on ""George" in the listbox where do you want the value to be entered?

sorry for that. I am familiar with vba. I explain in details.
on column D, I have 4 values Blacktown, Campbelltown, Granville, Hills. I want to use these values in Dropbox, I can do by vba but when I zoom out then I can not see properly in dropdown list.
and there are some Pivot charts linked to these values i.e. if I select "Blacktown" then Blacktown pivot chart values get changed , if I select Hills then Hills pivot chart values get changes.

it works fine but when I zoom out then very hard to view listbox contents .

 

[My Aswer Is This]

I'm not familiar with Pivot charts.
I assume they get there info from a certain cell.
Show me the vba script your using now.

And in what cells in column "D" are these values like:
Blacktown D1
Campbelltown D2

Would this be true? First four cells in column "D"

See my ideal would be to:
Have a script like:
Cells(1,3) .value = Listbox1.value

Instead of cells(1,1).value like you may be using now. The activex listbox can have large fonts.

When you click on the Activex listbox the script would run

The activex listbox font can be set to size 16 or 18 what ever you may like.

 

[tonyyy]

...when I zoom out then I can not see properly in dropdown list...

One solution would be to implement the code provided on the Contextures blog. The result is to zoom in when the dropdown is selected; otherwise the sheet is at a normal display.

Cheers,

tonyyy

 

[m_vishal_c]

...when I zoom out then I can not see properly in dropdown list...

One solution would be to implement the code provided on the Contextures blog. The result is to zoom in when the dropdown is selected; otherwise the sheet is at a normal display.

Cheers,

tonyyy

hi Tonny. thanks a lotttt...... it works perfectly. much much appreciated

thanks

 

[tonyyy]

You're very welcome...