Re: Height of Combobox

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

From: Bob (anonymous_at_discussions.microsoft.com.invalid)
Date: 07/30/04 

Date: Thu, 29 Jul 2004 17:25:19 -0700

Hi Don:

Thanks for the reply. What is the Forms 2.0 collection? Can you elaborate
on this a bit?

Thanks;

Bob

"Don Hanfland" <fakemail@no.spam> wrote in message
news:O7cDhYbdEHA.3632@TK2MSFTNGP09.phx.gbl...
> Hi Bob,
>
> Using the Standard Combox Control will not allow you to resize the
height,
> as it is based on the font size of the Combobox. There are other Combobox
> controls out there that will do and there is one within the Forms 2.0
> collection.
>
> Hope this helps!
> Don Hanfland [MVP - VB]
>
>
> "Bob" <anonymous@discussions.microsoft.com.invalid> wrote in message
> news:ORo0WgadEHA.2544@TK2MSFTNGP10.phx.gbl...
> > Hello all:
> >
> > I have an MSFlexGrid and the user inputs data into the grid through a
> > combobox. When the user click on any cell, I display the combobox. I
> want
> > the combobox to be the size of the cell, with the same font size. So,
for
> > example if the user chooses a font size of 12, to set the font size of
the
> > combobox to 12. This is easy enough. However, when the user resizes
the
> > rows, I need to be able to set the height of the combo box. Is there a
> way
> > to do this. I have not been able to find a way either on my own or on
the
> > internet.
> >
> > I appreciate your help.
> >
> > Bob
> >
> >
>
>

Relevant Pages

  • Re: Go To combobox
    ... Thanks Bob. ... I've managed to set the ListFillrange property successfully and ... the combobox be the go to cell. ...
    (microsoft.public.excel.programming)
  • Re: Dropdown List
    ... > A combobox will always allow a user to type data in it. ... Additionally you can turn of autoexpand so values do not ... > code on the keyup event of the combobox: ... >> Bob. ...
    (microsoft.public.access.forms)
  • Re: 2 column drop down lists
    ... Thanks Bob for the code - I've printed it out so as to review ... > Hi Jim, ... > If you want to pick up multiple columns from the combobox, ... > Private Sub ComboBox1_Click ...
    (microsoft.public.excel.misc)
  • Re: Height of Combobox
    ... > Hi Bob, ... There are other Combobox ... >> I have an MSFlexGrid and the user inputs data into the grid through a ... When the user click on any cell, ...
    (microsoft.public.vb.controls)
  • Re: how to make forms combo box jump to to of list
    ... You've used a combobox from the Forms Toolbar. ... What Bob is describing, ... and the behaviour that you want, is in a combobox from the Control Toolbox. ...
    (microsoft.public.excel.misc)