| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple column listbox syntex question
Nicely done Rob
Thanks a bunch, Martha -----Original Message----- Hi Martha, Here's one way to do it: MyVar = ListBox1.List(ListBox1.ListIndex, 4) -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Martha" wrote in message ... Hi, I have a 4 column single selection listbox on a userform. I have a variable (myvar) that I would like to assign the value of the selected items 4th column. ie myvar= listbox1.column(4).value that doesn't work. I am stumped. Please help. Thanks a bunch, Martha . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Proper syntex to use | Excel Discussion (Misc queries) | |||
| Moving Mutli-Column Multiple-Selected Listbox items up or down | Excel Discussion (Misc queries) | |||
| Syntex Error ?? | Excel Discussion (Misc queries) | |||
| Date format within a text syntex? | Excel Worksheet Functions | |||
| Multi-column ListBox. Multiple bound columns??? | Excel Programming | |||
![Martha[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
