If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Do E2K "comboboxes" work like in a db?
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 |
#3
|
|||
|
|||
Do E2K "comboboxes" work like in a db?
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 |
#4
|
|||
|
|||
Do E2K "comboboxes" work like in a db?
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 |
#5
|
|||
|
|||
Do E2K "comboboxes" work like in a db?
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. |
#6
|
|||
|
|||
Do E2K "comboboxes" work like in a db?
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 |
#7
|
|||
|
|||
Do E2K "comboboxes" work like in a db?
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. |
Thread Tools | |
Display Modes | |
|
|