I have created a drop down list, but when selected the text is really small. I know this is because I am zoomed out, but if there any way for the text to be larger so that I can zoom out and still read what the options for the dropdown list are?
I have created a drop down list, but when selected the text is really small. I know this is because I am zoomed out, but if there any way for the text to be larger so that I can zoom out and still read what the options for the dropdown list are?
Last edited by Back2Basics; 02-10-2009 at 10:04 AM.
You can't really... but here are some tips/tricks that might help...
http://www.contextures.com/xlDataVal08.html#Larger
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I'm not really sure how marcos work in excel.
I went to visual basics i excel, added a module and pasted the code that you directed me to.
but this didn't work, is there anything special that I have to do?
did you follow the instructions on inserting the code?
You have to right-click the tab for the sheet you are applying the code to and select View Code.. then paste the code in the editor there.
In the code you will need to change the reference of the target address (i.e. $A$2) to the location your drop down cell is at.
thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks