I am trying to have a combo box on a sheet in Excel where I can select the
value from the box to fill the active cell. I was able to go as far as making
the combo and inserting the value but I will have to make a box for every
cell that I need to make entry in. I would really appreciate if some one
could help me on that.
thanks
Al

Try google or check Excel help for data validation. It could help you.

You can use the list option under Data=Validation (Validation under the
data menu). You can select all the cells you want to have a dropdown and
apply Data=Validation all at once. The dropdown will appear when you
select the cell.

--
Regards,
Tom Ogilvy

"Al" wrote in message
...
I am trying to have a combo box on a sheet in Excel where I can select the
value from the box to fill the active cell. I was able to go as far as
making
the combo and inserting the value but I will have to make a box for every
cell that I need to make entry in. I would really appreciate if some one
could help me on that.
thanks
Al

I am not sure if I understand how to relate this to my question. I may have
not been clear. I want to have a combo box (cboJobType) say in cell A1 the
cboJobType contains the following values (Yes,No,UNK). Now say I selected
Cell A3 for the data entry, is it possible to click on the cboJobType and
select, Say, UNK then go to cell A6 and again use the cboJobType to select
anoth value for this cell and so on? how can I do that.
thanks

"Tom Ogilvy" wrote:

You can use the list option under Data=Validation (Validation under the
data menu). You can select all the cells you want to have a dropdown and
apply Data=Validation all at once. The dropdown will appear when you
select the cell.

--
Regards,
Tom Ogilvy

"Al" wrote in message
...
I am trying to have a combo box on a sheet in Excel where I can select the
value from the box to fill the active cell. I was able to go as far as
making
the combo and inserting the value but I will have to make a box for every
cell that I need to make entry in. I would really appreciate if some one
could help me on that.
thanks
Al

Private Sub cboJobType_Click()
if ActiveCell.Column = 1 then
ActiveCell.Value = cboJobType.Value
end if
End Sub

right click on the sheet tab and put in code similar to the above.

--
Regards,
Tom Ogilvy


"Al" wrote in message
...
I am not sure if I understand how to relate this to my question. I may
have
not been clear. I want to have a combo box (cboJobType) say in cell A1 the
cboJobType contains the following values (Yes,No,UNK). Now say I selected
Cell A3 for the data entry, is it possible to click on the cboJobType and
select, Say, UNK then go to cell A6 and again use the cboJobType to select
anoth value for this cell and so on? how can I do that.
thanks

"Tom Ogilvy" wrote:

You can use the list option under Data=Validation (Validation under the
data menu). You can select all the cells you want to have a dropdown
and
apply Data=Validation all at once. The dropdown will appear when you
select the cell.

--
Regards,
Tom Ogilvy

"Al" wrote in message
...
I am trying to have a combo box on a sheet in Excel where I can select
the
value from the box to fill the active cell. I was able to go as far as
making
the combo and inserting the value but I will have to make a box for
every
cell that I need to make entry in. I would really appreciate if some
one
could help me on that.
thanks
Al