in-cell on-the-fly list/combo box
 

I am not sure how to express this and thus have had no luck searching if it
has been asked before.

I have seen spreadsheets where, upon entering a cell which "accepts" certain
input (Yes/No, True/False etc), a list or combo box is "created" on the fly
within the cell and restricts input to the predefined values.

Can anyone explain how it is done or where I can find information?

Thanks for bearing with me!

in-cell on-the-fly list/combo box
 

Look for help on: Data Validation.

Good Luck.

"DoctorG" wrote:

I am not sure how to express this and thus have had no luck searching if it
has been asked before.

I have seen spreadsheets where, upon entering a cell which "accepts" certain
input (Yes/No, True/False etc), a list or combo box is "created" on the fly
within the cell and restricts input to the predefined values.

Can anyone explain how it is done or where I can find information?

Thanks for bearing with me!

in-cell on-the-fly list/combo box
 

Thanks ND Pard. I looked up "Data Validation" in Help and the following code
did the trick.

With ActiveCell.Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange"
.InCellDropdown = True
End With

"ND Pard" wrote:

Look for help on: Data Validation.

Good Luck.

"DoctorG" wrote:

I am not sure how to express this and thus have had no luck searching if it
has been asked before.

I have seen spreadsheets where, upon entering a cell which "accepts" certain
input (Yes/No, True/False etc), a list or combo box is "created" on the fly
within the cell and restricts input to the predefined values.

Can anyone explain how it is done or where I can find information?

Thanks for bearing with me!

in-cell on-the-fly list/combo box
 

Just so you are aware... you can do that from the menu bar as well (click
Data/Validation and fill-in the dialog box).

--
Rick (MVP - Excel)


"DoctorG" wrote in message
...
Thanks ND Pard. I looked up "Data Validation" in Help and the following
code
did the trick.

With ActiveCell.Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange"
.InCellDropdown = True
End With

"ND Pard" wrote:

Look for help on: Data Validation.

Good Luck.

"DoctorG" wrote:

I am not sure how to express this and thus have had no luck searching
if it
has been asked before.

I have seen spreadsheets where, upon entering a cell which "accepts"
certain
input (Yes/No, True/False etc), a list or combo box is "created" on the
fly
within the cell and restricts input to the predefined values.

Can anyone explain how it is done or where I can find information?

Thanks for bearing with me!

in-cell on-the-fly list/combo box
 

Weeeellllllll...... it was kinda easier than I thought......

Ok, Rick, point well taken : learn the basics, then move on.

Nevertheless I "touched" things I wouldn't have otherwise.

Thanks a lot, both of you !!!!!

Now what about the next question concerning Worksheet_Change after the
validation?

"Rick Rothstein" wrote:

Just so you are aware... you can do that from the menu bar as well (click
Data/Validation and fill-in the dialog box).

--
Rick (MVP - Excel)


"DoctorG" wrote in message
...
Thanks ND Pard. I looked up "Data Validation" in Help and the following
code
did the trick.

With ActiveCell.Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange"
.InCellDropdown = True
End With

"ND Pard" wrote:

Look for help on: Data Validation.

Good Luck.

"DoctorG" wrote:

I am not sure how to express this and thus have had no luck searching
if it
has been asked before.

I have seen spreadsheets where, upon entering a cell which "accepts"
certain
input (Yes/No, True/False etc), a list or combo box is "created" on the
fly
within the cell and restricts input to the predefined values.

Can anyone explain how it is done or where I can find information?

Thanks for bearing with me!

in-cell on-the-fly list/combo box
 

I don't see an earlier question from you regarding Worksheet_Change and your
brief mention of it is not enough to figure out what your actual need is
related to it... can you provide more detail please?

--
Rick (MVP - Excel)


"DoctorG" wrote in message
...
Weeeellllllll...... it was kinda easier than I thought......

Ok, Rick, point well taken : learn the basics, then move on.

Nevertheless I "touched" things I wouldn't have otherwise.

Thanks a lot, both of you !!!!!

Now what about the next question concerning Worksheet_Change after the
validation?

"Rick Rothstein" wrote:

Just so you are aware... you can do that from the menu bar as well (click
Data/Validation and fill-in the dialog box).

--
Rick (MVP - Excel)


"DoctorG" wrote in message
...
Thanks ND Pard. I looked up "Data Validation" in Help and the following
code
did the trick.

With ActiveCell.Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange"
.InCellDropdown = True
End With

"ND Pard" wrote:

Look for help on: Data Validation.

Good Luck.

"DoctorG" wrote:

I am not sure how to express this and thus have had no luck
searching
if it
has been asked before.

I have seen spreadsheets where, upon entering a cell which "accepts"
certain
input (Yes/No, True/False etc), a list or combo box is "created" on
the
fly
within the cell and restricts input to the predefined values.

Can anyone explain how it is done or where I can find information?

Thanks for bearing with me!

in-cell on-the-fly list/combo box
 

Sorry Rick, it's not an earlier question. It's the second question after this
one. You see it became evident after I had the validation in place. Bernie is
trying to help on that as we "speak".

"Rick Rothstein" wrote:

I don't see an earlier question from you regarding Worksheet_Change and your
brief mention of it is not enough to figure out what your actual need is
related to it... can you provide more detail please?

--
Rick (MVP - Excel)


"DoctorG" wrote in message
...
Weeeellllllll...... it was kinda easier than I thought......

Ok, Rick, point well taken : learn the basics, then move on.

Nevertheless I "touched" things I wouldn't have otherwise.

Thanks a lot, both of you !!!!!

Now what about the next question concerning Worksheet_Change after the
validation?

"Rick Rothstein" wrote:

Just so you are aware... you can do that from the menu bar as well (click
Data/Validation and fill-in the dialog box).

--
Rick (MVP - Excel)


"DoctorG" wrote in message
...
Thanks ND Pard. I looked up "Data Validation" in Help and the following
code
did the trick.

With ActiveCell.Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange"
.InCellDropdown = True
End With

"ND Pard" wrote:

Look for help on: Data Validation.

Good Luck.

"DoctorG" wrote:

I am not sure how to express this and thus have had no luck
searching
if it
has been asked before.

I have seen spreadsheets where, upon entering a cell which "accepts"
certain
input (Yes/No, True/False etc), a list or combo box is "created" on
the
fly
within the cell and restricts input to the predefined values.

Can anyone explain how it is done or where I can find information?

Thanks for bearing with me!