sometimes it takes one variable, sometimes another ...
The RowSource property for each of
Listbox the_month,
listbox the_day,
listbox the_year
is set to a column on my spreadsheet.
ie:
Mo. Day Year
F G H
1 Jan. 1 2005
2 Feb. 2 2006
3 March 3 2007
4 April 4 2008
5 May 5
6 June 6
7 July 7
8 Aug. 8
9 Sept. 9
10 Oc.t 10
11 Nov. 11
12 Dec. 12
13 13
14 14
etc. to 31
Shawn O'Donnell wrote:
Start is the name of the macro to begin ... Tools|Macro|Macro ...
start
No errors, but the variables are not being stored/passed/used UNLESS,
once the user form loads, you make a change IN the listboxes. THEN, it
takes the values in the listboxes.
"Larry Levinson" wrote:
dayprompt the form has three list boxes, the_Month, the_Day, the_year
Tell us how you have the list boxes set up. Are the list values on a
spreadsheet somewhere, or do you add them programmatically? Are the values
you're trying to set the .Text property to actually in the lists?
Where does start() get called from?
And you're not getting any errors--just sporadic results?
Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)
|