Questions About ComboBox

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chaplain Doug (ChaplainDoug_at_discussions.microsoft.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 13:11:03 -0800

I have added a combobox to an Excel sheet. The values for the list are set
programmatically by placing them in cells in the worksheet.

1. There are 71 or more values that I need to appear in this combo list.
Only 40 of them appear on the screen when I open the combo list. How can I
get a vertical scroll bar on the list so that I may get to all the values in
the list?

2. Is there another way to specify the list values other than placing them
in cells in the worksheet and setting the ListFillRange? 

-- 
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

Relevant Pages

  • Re: protect a protected worksheet
    ... Lock the cells that the user's shouldn't change and reprotect the worksheet with ... > I have got one Excel sheet which is password protected some of the users know ...
    (microsoft.public.excel.misc)
  • Re: Macro to insert this formula automatically on start up
    ... > I need an excel sheet to automatically run a macro on click command, ... > is inserted in all cells in the worksheet. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • RE: Macro / Programming to lock cells
    ... Yes you can by allowing 'Objects' to be edited when you apply your worksheet ... protection. ... I have an excel sheet and need certain cells to be locked down which isn't a ... cells, is this possible? ...
    (microsoft.public.excel.misc)
  • RE: AVERAGE cells on another worksheet when the range is calculated
    ... That is a very confusing paragraph. ... Where 5 is telling the formula to average cells A1:A5. ... By placing different ... main worksheet ...
    (microsoft.public.excel.misc)
  • Changing Border Thickness Throughout Document
    ... I have an Excel sheet that has bordered text all over the document. ... kind of like a flow chart, in a way, so not all cells have the borders. ... want to change the color and line of the border throughout a selected range, ... which limits me when it's an entire worksheet. ...
    (microsoft.public.excel.misc)