Hi,
Is there a way to use listboxes as input?
I want it to work the same way InputBox works, only instead of a single
editing line there will be a list the user can choose from.

Have you looked at Data Validation. Check it out at
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Yossi" wrote in message
...
Hi,
Is there a way to use listboxes as input?
I want it to work the same way InputBox works, only instead of a single
editing line there will be a list the user can choose from.

yes, I know how to use data validation, but Data validation is not what I need.
I need to use it as a popup dialog.
For example when a cell is being changed I want to trigger this list box to
get additional information from the user. basically I want to trigger this
from the change event.

"Bob Phillips" wrote:

Have you looked at Data Validation. Check it out at
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Yossi" wrote in message
...
Hi,
Is there a way to use listboxes as input?
I want it to work the same way InputBox works, only instead of a single
editing line there will be a list the user can choose from.

trying to understand, if user enter info in cell, do you want the following
to happen, if entry matches existing data fine, if not present a user form to
axcept new data for possible future validation if entered again.
--
Jim at Eagle


"Yossi" wrote:

yes, I know how to use data validation, but Data validation is not what I need.
I need to use it as a popup dialog.
For example when a cell is being changed I want to trigger this list box to
get additional information from the user. basically I want to trigger this
from the change event.

"Bob Phillips" wrote:

Have you looked at Data Validation. Check it out at
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Yossi" wrote in message
...
Hi,
Is there a way to use listboxes as input?
I want it to work the same way InputBox works, only instead of a single
editing line there will be a list the user can choose from.

Yossi,

Put a listbox on a userform and show the userform from your change event.
Put a commandbutton on the form too, that they can press when they've made
their choice. In the code for the commandbutton assign the listbox value to
wherever and then unload the userform. The listbox has a rowsource or you
can add the items at runtime.

hth,

Doug

"Yossi" wrote in message
...
yes, I know how to use data validation, but Data validation is not what I
need.
I need to use it as a popup dialog.
For example when a cell is being changed I want to trigger this list box
to
get additional information from the user. basically I want to trigger this
from the change event.

"Bob Phillips" wrote:

Have you looked at Data Validation. Check it out at
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Yossi" wrote in message
...
Hi,
Is there a way to use listboxes as input?
I want it to work the same way InputBox works, only instead of a single
editing line there will be a list the user can choose from.

Thanks, Doug, I think this is what I was looking for.

"Doug Glancy" wrote:

Yossi,

Put a listbox on a userform and show the userform from your change event.
Put a commandbutton on the form too, that they can press when they've made
their choice. In the code for the commandbutton assign the listbox value to
wherever and then unload the userform. The listbox has a rowsource or you
can add the items at runtime.

hth,

Doug

"Yossi" wrote in message
...
yes, I know how to use data validation, but Data validation is not what I
need.
I need to use it as a popup dialog.
For example when a cell is being changed I want to trigger this list box
to
get additional information from the user. basically I want to trigger this
from the change event.

"Bob Phillips" wrote:

Have you looked at Data Validation. Check it out at
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Yossi" wrote in message
...
Hi,
Is there a way to use listboxes as input?
I want it to work the same way InputBox works, only instead of a single
editing line there will be a list the user can choose from.