Quote:
Originally Posted by Guessed
Relatively simple? No
But the right way to do it would be using a UserForm and listbox control.
|
That's what I thought. I've been meaning to learn UserForms for a while. This may be the push I need.
Can I trouble you to post a basic skeleton for how to get started?
Given these variables:
Code:
Dim MaxNum as Long
Dim iRow() as Long
Dim dDays() as Double
Dim sTitle() as String
As the code runs, these arrays get ReDim'd to (1 To MaxNum).
I'd like the UserForm to display one line for each row or the arrays plus this title so that everything lines up:
Code:
Row Days Title
1 3.25 Title #1
2 12.67 Title #2
3 0.17 Title #3
4 14.50 Title #4
. . .
And then give the user the option of selecting one of the rows by number.
Thanks