Do E2K "comboboxes" work like in a db?

On Wed, 09 Jun 2004 23:36:59 -0400, StargateFan
wrote:

On Wed, 09 Jun 2004 18:51:30 -0500, Dave Peterson
wrote:

There are comboboxes (aka dropdowns) on the Forms toolbar.

There are comboboxes on the Control toolbox toolbar.

And there is Data|Validation that looks very similar to a combobox/dropdown.

You may want to look at Data|Validation first. I find it the easiest to
implement.

And you could visit Debra Dalgleish's site for lots of info on Data|Validation.
http://www.contextures.com/xlDataVal01.html

Excellent! Now that is a page that seems to cover it all. I'll give
it a shot.

The example clinched this! I couldn't figure out initially where to
put the data list, but the example showed a blank kind of sheet at the
end with this. It's so neat that Excel picks up the reference no
matter where you put it! g But I couldn't risk someone
accidentally deleting a line that contained the list somewhere off,
unseen. But by putting a sheet at the very end with a "do not delete"
reference in the sheet name, that made it ideal!

Thanks so very much for this.

She wanted a db without a db and wanted me to use Excel. I'm
delivering thanks to all the wonderful help. (Sad thing is that she
won't know or appreciate just what the heck she's getting! lol
Ain't that life all over! g)

Cheers!

Thanks!

StargateFan wrote:

I searched in the help file and the one labelled "About control
properties for Forms toolbar list boxes and combo boxes" tells me,
when reading behind the lines, that it does. But I'd just like that
comfirmed. Also, if it does, can someone direct me to a good tutorial
or help URL? The help file didn't help me in this case.

I stumbled upon the combo box when I was in the toolbox the other day.
it would be sooo neat if they emulate the behaviour that one can find
in databases (where a value list can be added and items entered for
user to choose from).

Thanks so much.

StargateFan wrote

The example clinched this! I couldn't figure out initially where to
put the data list, but the example showed a blank kind of sheet at the
end with this.

Or you could hide the sheet with the data list:
Format|Sheet|Hide

--
David

Thanks for your comment about not knowing where to put the list. I've
added a couple of lines to the instructions in Step 1, so I hope it's
clearer now.

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

StargateFan wrote:
On Wed, 09 Jun 2004 23:36:59 -0400, StargateFan
wrote:


On Wed, 09 Jun 2004 18:51:30 -0500, Dave Peterson
wrote:


There are comboboxes (aka dropdowns) on the Forms toolbar.

There are comboboxes on the Control toolbox toolbar.

And there is Data|Validation that looks very similar to a combobox/dropdown.

You may want to look at Data|Validation first. I find it the easiest to
implement.

And you could visit Debra Dalgleish's site for lots of info on Data|Validation.
http://www.contextures.com/xlDataVal01.html

Excellent! Now that is a page that seems to cover it all. I'll give
it a shot.


The example clinched this! I couldn't figure out initially where to
put the data list, but the example showed a blank kind of sheet at the
end with this. It's so neat that Excel picks up the reference no
matter where you put it! g But I couldn't risk someone
accidentally deleting a line that contained the list somewhere off,
unseen. But by putting a sheet at the very end with a "do not delete"
reference in the sheet name, that made it ideal!

Thanks so very much for this.

She wanted a db without a db and wanted me to use Excel. I'm
delivering thanks to all the wonderful help. (Sad thing is that she
won't know or appreciate just what the heck she's getting! lol
Ain't that life all over! g)

Cheers!


Thanks!


StargateFan wrote:

I searched in the help file and the one labelled "About control
properties for Forms toolbar list boxes and combo boxes" tells me,
when reading behind the lines, that it does. But I'd just like that
comfirmed. Also, if it does, can someone direct me to a good tutorial
or help URL? The help file didn't help me in this case.

I stumbled upon the combo box when I was in the toolbox the other day.
it would be sooo neat if they emulate the behaviour that one can find
in databases (where a value list can be added and items entered for
user to choose from).

Thanks so much.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

On Sat, 12 Jun 2004 04:36:42 -0700, David
wrote:

StargateFan wrote

The example clinched this! I couldn't figure out initially where to
put the data list, but the example showed a blank kind of sheet at the
end with this.

Or you could hide the sheet with the data list:
Format|Sheet|Hide

Wow, I didn't know that. Will do first thing on Monday! Now no-one
will be able to tamper with the workbook unless they know how and do
it on purpose. Amazing. g

On Sat, 12 Jun 2004 08:18:40 -0400, Debra Dalgleish
wrote:

Thanks for your comment about not knowing where to put the list. I've

Um, you mean being an idiot newbie paid off for once??! rofl

added a couple of lines to the instructions in Step 1, so I hope it's
clearer now.

I didn't realize that you'd written this. It's a great set of
instructions and the example file really, really helped.

But I also found that what Dave said is also extremely valuable; as he
said to me after I'd written putting the data on a completely
different sheet from the main one as per the example in your webpage,
but put in the sheet name "do not delete" :

"Or you could hide the sheet with the data list:
Format|Sheet|Hide"

If you could add a little blurb like that in, I feel it would be
really great for users such as myself who didn't know about hiding
sheets. Heck, I only just found out about hiding and unhiding books
like the PERSONAL.XLS one - a file I also only found out about in the
last several months g.

Those who already know, great. The info will only be superfluous to
them; but those that don't know, they'll learn something new as I did.

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

I gather that you put it he

"1. Create a List of Items

If the list of options is more than a couple of items, it's easier to
maintain if you type the list on a worksheet. The list can be entered
on the same sheet that will contain the dropdown lists, or on a
different sheet. In this example, the list will be stored on a sheet
named Lists."

Yes, that's a little bit clearer. Wonderful!

Thanks everyone!

StargateFan wrote:
On Wed, 09 Jun 2004 23:36:59 -0400, StargateFan
wrote:


On Wed, 09 Jun 2004 18:51:30 -0500, Dave Peterson
wrote:


There are comboboxes (aka dropdowns) on the Forms toolbar.

There are comboboxes on the Control toolbox toolbar.

And there is Data|Validation that looks very similar to a combobox/dropdown.

You may want to look at Data|Validation first. I find it the easiest to
implement.

And you could visit Debra Dalgleish's site for lots of info on Data|Validation.
http://www.contextures.com/xlDataVal01.html

Excellent! Now that is a page that seems to cover it all. I'll give
it a shot.


The example clinched this! I couldn't figure out initially where to
put the data list, but the example showed a blank kind of sheet at the
end with this. It's so neat that Excel picks up the reference no
matter where you put it! g But I couldn't risk someone
accidentally deleting a line that contained the list somewhere off,
unseen. But by putting a sheet at the very end with a "do not delete"
reference in the sheet name, that made it ideal!

Thanks so very much for this.

She wanted a db without a db and wanted me to use Excel. I'm
delivering thanks to all the wonderful help. (Sad thing is that she
won't know or appreciate just what the heck she's getting! lol
Ain't that life all over! g)

Cheers!


Thanks!


StargateFan wrote:

I searched in the help file and the one labelled "About control
properties for Forms toolbar list boxes and combo boxes" tells me,
when reading behind the lines, that it does. But I'd just like that
comfirmed. Also, if it does, can someone direct me to a good tutorial
or help URL? The help file didn't help me in this case.

I stumbled upon the combo box when I was in the toolbox the other day.
it would be sooo neat if they emulate the behaviour that one can find
in databases (where a value list can be added and items entered for
user to choose from).

Thanks so much.

Thanks again! You're just full of good ideas, aren't you? vbg

I've added a note about hiding the sheet to protect the list from
accidental damage.

StargateFan wrote:
On Sat, 12 Jun 2004 08:18:40 -0400, Debra Dalgleish
wrote:


Thanks for your comment about not knowing where to put the list. I've


Um, you mean being an idiot newbie paid off for once??! rofl

added a couple of lines to the instructions in Step 1, so I hope it's
clearer now.


I didn't realize that you'd written this. It's a great set of
instructions and the example file really, really helped.

But I also found that what Dave said is also extremely valuable; as he
said to me after I'd written putting the data on a completely
different sheet from the main one as per the example in your webpage,
but put in the sheet name "do not delete" :

"Or you could hide the sheet with the data list:
Format|Sheet|Hide"

If you could add a little blurb like that in, I feel it would be
really great for users such as myself who didn't know about hiding
sheets. Heck, I only just found out about hiding and unhiding books
like the PERSONAL.XLS one - a file I also only found out about in the
last several months g.

Those who already know, great. The info will only be superfluous to
them; but those that don't know, they'll learn something new as I did.


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


I gather that you put it he

"1. Create a List of Items

If the list of options is more than a couple of items, it's easier to
maintain if you type the list on a worksheet. The list can be entered
on the same sheet that will contain the dropdown lists, or on a
different sheet. In this example, the list will be stored on a sheet
named Lists."

Yes, that's a little bit clearer. Wonderful!

Thanks everyone!


StargateFan wrote:

On Wed, 09 Jun 2004 23:36:59 -0400, StargateFan
wrote:



On Wed, 09 Jun 2004 18:51:30 -0500, Dave Peterson
wrote:



There are comboboxes (aka dropdowns) on the Forms toolbar.

There are comboboxes on the Control toolbox toolbar.

And there is Data|Validation that looks very similar to a combobox/dropdown.

You may want to look at Data|Validation first. I find it the easiest to
implement.

And you could visit Debra Dalgleish's site for lots of info on Data|Validation.
http://www.contextures.com/xlDataVal01.html

Excellent! Now that is a page that seems to cover it all. I'll give
it a shot.


The example clinched this! I couldn't figure out initially where to
put the data list, but the example showed a blank kind of sheet at the
end with this. It's so neat that Excel picks up the reference no
matter where you put it! g But I couldn't risk someone
accidentally deleting a line that contained the list somewhere off,
unseen. But by putting a sheet at the very end with a "do not delete"
reference in the sheet name, that made it ideal!

Thanks so very much for this.

She wanted a db without a db and wanted me to use Excel. I'm
delivering thanks to all the wonderful help. (Sad thing is that she
won't know or appreciate just what the heck she's getting! lol
Ain't that life all over! g)

Cheers!



Thanks!



StargateFan wrote:


I searched in the help file and the one labelled "About control
properties for Forms toolbar list boxes and combo boxes" tells me,
when reading behind the lines, that it does. But I'd just like that
comfirmed. Also, if it does, can someone direct me to a good tutorial
or help URL? The help file didn't help me in this case.

I stumbled upon the combo box when I was in the toolbox the other day.
it would be sooo neat if they emulate the behaviour that one can find
in databases (where a value list can be added and items entered for
user to choose from).

Thanks so much.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

On Sat, 12 Jun 2004 12:21:18 -0400, Debra Dalgleish
wrote:

Thanks again! You're just full of good ideas, aren't you? vbg

vbg

I've added a note about hiding the sheet to protect the list from
accidental damage.

Super, I'll have to go again to check it out.

Thanks!

StargateFan wrote:
On Sat, 12 Jun 2004 08:18:40 -0400, Debra Dalgleish
wrote:


Thanks for your comment about not knowing where to put the list. I've


Um, you mean being an idiot newbie paid off for once??! rofl

added a couple of lines to the instructions in Step 1, so I hope it's
clearer now.


I didn't realize that you'd written this. It's a great set of
instructions and the example file really, really helped.

But I also found that what Dave said is also extremely valuable; as he
said to me after I'd written putting the data on a completely
different sheet from the main one as per the example in your webpage,
but put in the sheet name "do not delete" :

"Or you could hide the sheet with the data list:
Format|Sheet|Hide"

If you could add a little blurb like that in, I feel it would be
really great for users such as myself who didn't know about hiding
sheets. Heck, I only just found out about hiding and unhiding books
like the PERSONAL.XLS one - a file I also only found out about in the
last several months g.

Those who already know, great. The info will only be superfluous to
them; but those that don't know, they'll learn something new as I did.


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


I gather that you put it he

"1. Create a List of Items

If the list of options is more than a couple of items, it's easier to
maintain if you type the list on a worksheet. The list can be entered
on the same sheet that will contain the dropdown lists, or on a
different sheet. In this example, the list will be stored on a sheet
named Lists."

Yes, that's a little bit clearer. Wonderful!

Thanks everyone!


StargateFan wrote:

On Wed, 09 Jun 2004 23:36:59 -0400, StargateFan
wrote:



On Wed, 09 Jun 2004 18:51:30 -0500, Dave Peterson
wrote:



There are comboboxes (aka dropdowns) on the Forms toolbar.

There are comboboxes on the Control toolbox toolbar.

And there is Data|Validation that looks very similar to a combobox/dropdown.

You may want to look at Data|Validation first. I find it the easiest to
implement.

And you could visit Debra Dalgleish's site for lots of info on Data|Validation.
http://www.contextures.com/xlDataVal01.html

Excellent! Now that is a page that seems to cover it all. I'll give
it a shot.


The example clinched this! I couldn't figure out initially where to
put the data list, but the example showed a blank kind of sheet at the
end with this. It's so neat that Excel picks up the reference no
matter where you put it! g But I couldn't risk someone
accidentally deleting a line that contained the list somewhere off,
unseen. But by putting a sheet at the very end with a "do not delete"
reference in the sheet name, that made it ideal!

Thanks so very much for this.

She wanted a db without a db and wanted me to use Excel. I'm
delivering thanks to all the wonderful help. (Sad thing is that she
won't know or appreciate just what the heck she's getting! lol
Ain't that life all over! g)

Cheers!



Thanks!



StargateFan wrote:


I searched in the help file and the one labelled "About control
properties for Forms toolbar list boxes and combo boxes" tells me,
when reading behind the lines, that it does. But I'd just like that
comfirmed. Also, if it does, can someone direct me to a good tutorial
or help URL? The help file didn't help me in this case.

I stumbled upon the combo box when I was in the toolbox the other day.
it would be sooo neat if they emulate the behaviour that one can find
in databases (where a value list can be added and items entered for
user to choose from).

Thanks so much.