Do E2K "comboboxes" work like in a db?

S

StargateFan

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.
 
D

Dave Peterson

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
 
S

StargateFan

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
Click to expand...

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

Thanks!
 
S

StargateFan

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

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!
 
D

David

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.
Click to expand...

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

StargateFan

StargateFan wrote


Or you could hide the sheet with the data list:
Format|Sheet|Hide
Click to expand...

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>
 
S

StargateFan

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

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

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
Click to expand...

I gather that you put it here:

"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!
 
D

Debra Dalgleish

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.
 
Top