-
Quick question about Listboxes
Hello,
I'm sure I'm missing something obvious, but I've searched around and can't find the answer.
I'm working with a Userform, and on it is a listbox. The user submits an amount of entries, say 10. Once that's done, I want to extract a particular entry via VBA and assign it to a variable.
For example, say I want to assign entry number 6 to the variable n...
Pseudocode being:
n = lstListBox1.getvalue(6)
What code should I be using?
Thanks,
Charlie.
-
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
Originally Posted by
mdmackillop
you're a star cheers pal
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules