Prev: search column for duplicate value during data entry
Next: SOS-Need to calculate number of working hours per each week of
From: BlueWolverine on 31 Mar 2010 14:28
Hello,
MS Excel 2003 on XP PRO.

I'm looking to generate a popup (msg box or input box) that instead of free
form text has a "combobox" or "pulldown" to it. So that the user picks a
value from a list, and hits OK. This way they can't input incorrect values.

Is this possible? If not I have back up methods but this would be PERFECT
for my application.

Thanks,
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!
From: Gord Dibben on 31 Mar 2010 14:52
Many options here.

From a simple worksheet Data Validation List to a UserForm with controls.

In between can be Combox, ListBox etc.

Depends what you want to do with the selection.


Gord Dibben MS Excel MVP

On Wed, 31 Mar 2010 11:28:03 -0700, BlueWolverine
<BlueWolverine(a)discussions.microsoft.com> wrote:

>Hello,
>MS Excel 2003 on XP PRO.
>
>I'm looking to generate a popup (msg box or input box) that instead of free
>form text has a "combobox" or "pulldown" to it. So that the user picks a
>value from a list, and hits OK. This way they can't input incorrect values.
>
>Is this possible? If not I have back up methods but this would be PERFECT
>for my application.
>
>Thanks,

From: JLGWhiz on 31 Mar 2010 17:41
You might find this helpful:

http://www.contextures.com/xlUserForm01.html

It gives several examples of how to create a UserForm and put controls on
it, which is baxically what you are asking about in your post.


"BlueWolverine" <BlueWolverine(a)discussions.microsoft.com> wrote in message
news:69D0D8AB-309A-4046-BC30-6876F9802D24(a)microsoft.com...
> Hello,
> MS Excel 2003 on XP PRO.
>
> I'm looking to generate a popup (msg box or input box) that instead of
> free
> form text has a "combobox" or "pulldown" to it. So that the user picks a
> value from a list, and hits OK. This way they can't input incorrect
> values.
>
> Is this possible? If not I have back up methods but this would be PERFECT
> for my application.
>
> Thanks,
> --
> BlueWolverine
> MSE - Mech. Eng.
> Go BLUE!


 | 
Pages: 1
Prev: search column for duplicate value during data entry
Next: SOS-Need to calculate number of working hours per each week of