Re: Pop-up Combo Box

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 20:02:55 +0200

Hi Bob
he should but I did not see your advice? (or was this a different post) 

--
Regards
Frank Kabel
Frankfurt, Germany
Bob Phillips wrote:
> Frank,
>
> If he takes my advice (and why wouldn't he<vbg>?) the second question
> becomes redundant.
>
>
> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> news:uKzNDDZHEHA.2668@TK2MSFTNGP10.phx.gbl...
>> Hi Brad
>> for the second question use either the workbook_open event (in your
>> workbook module) or name your macro Auto_Open()
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>>
>> Brad E wrote:
>>> There is a spread*** which four people will be using,
>>> and I need to know which of the four will be using for
>>> formatting.  Upon opening the 'template' workbook, I would
>>> like a pop-up drop-down list of the user's names, which
>>> they will have to select before entering on the
>>> spread***.
>>> I would like to know two things: 1)how do I make the Combo
>>> Box pop-up, 2)how do I make this pop up when the workbook
>>> is open?
>>> Thanks, Brad E.
Quantcast