Prev: Macro match function problem
Next: Splitting cells
From: Steve M on 5 May 2010 04:42
Hi
I have a data validation list which I use in the spreadsheet for the user to
select from the drop down. I would like the user to be able to user a data
entry form instead of adding to the master sheet. Is there any way I can
create a form for this that will use the validation list drop down. When I
tried 'data' and 'form' it only has text boxes.
From: Bob Phillips on 5 May 2010 04:52
Unfortunately, that is just a very simple form.

If you want richer controls, you will need to build your own userform, add
the controls, and use VBA to control it.

--

HTH

Bob

"Steve M" <SteveM(a)discussions.microsoft.com> wrote in message
news:AE6120A4-05A7-48C2-ADB8-2505CD976860(a)microsoft.com...
> Hi
> I have a data validation list which I use in the spreadsheet for the user
> to
> select from the drop down. I would like the user to be able to user a
> data
> entry form instead of adding to the master sheet. Is there any way I can
> create a form for this that will use the validation list drop down. When
> I
> tried 'data' and 'form' it only has text boxes.


From: Jacob Skaria on 5 May 2010 05:05
Add a combobox from the toolbox and set the Rowsource prooperty to a cell
range.
--
Jacob (MVP - Excel)


"Steve M" wrote:

> Hi
> I have a data validation list which I use in the spreadsheet for the user to
> select from the drop down. I would like the user to be able to user a data
> entry form instead of adding to the master sheet. Is there any way I can
> create a form for this that will use the validation list drop down. When I
> tried 'data' and 'form' it only has text boxes.
From: Jacob Skaria on 5 May 2010 06:05
If you are new to VBA ; from workbook launch VBE using short-key Alt+F11.
From menu 'Insert' a 'UserForm' and check out the toolbox controls
available...

Also check out the topic 'Excel Data Entry Worksheet Form' by Dave Peterson
which do not use a userform
http://www.contextures.com/xlForm02.html

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

> Add a combobox from the toolbox and set the Rowsource prooperty to a cell
> range.
> --
> Jacob (MVP - Excel)
>
>
> "Steve M" wrote:
>
> > Hi
> > I have a data validation list which I use in the spreadsheet for the user to
> > select from the drop down. I would like the user to be able to user a data
> > entry form instead of adding to the master sheet. Is there any way I can
> > create a form for this that will use the validation list drop down. When I
> > tried 'data' and 'form' it only has text boxes.
From: Steve M on 5 May 2010 14:21
Many thanks for the tip, I will defiantly have to go down this route.

"Bob Phillips" wrote:

> Unfortunately, that is just a very simple form.
>
> If you want richer controls, you will need to build your own userform, add
> the controls, and use VBA to control it.
>
> --
>
> HTH
>
> Bob
>
> "Steve M" <SteveM(a)discussions.microsoft.com> wrote in message
> news:AE6120A4-05A7-48C2-ADB8-2505CD976860(a)microsoft.com...
> > Hi
> > I have a data validation list which I use in the spreadsheet for the user
> > to
> > select from the drop down. I would like the user to be able to user a
> > data
> > entry form instead of adding to the master sheet. Is there any way I can
> > create a form for this that will use the validation list drop down. When
> > I
> > tried 'data' and 'form' it only has text boxes.
>
>
> .
>
 | 
Pages: 1
Prev: Macro match function problem
Next: Splitting cells