| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
using listboxes as input
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| listboxes | Excel Programming | |||
| listboxes | Excel Programming | |||
| Listboxes 2 | Excel Programming | |||
| listboxes | Excel Programming | |||
| Listboxes | Excel Programming | |||
![Yossi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
