Send Userform results to worksheet
- From: "TimT" <TimT@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Jul 2005 14:53:05 -0700
I have a userform that prompts the user for information that will be used in
formulas and in some vba code. The userform contains:
listbox1 - which collects the month
listbox2 - which collects the year
listbox3 - which collects one of two variables
Textbox - Company name
The value of listbox3 needs to reference to in an IF statement and the other
three (listboxes 1 & 2 and textbox are all concatenated in a saveas command
to form a file name.
What would be the best way to reference these values?
Or would it be easier to send the values to a specific cell to be referenced?
.
- Follow-Ups:
- Re: Send Userform results to work***
- From: Dave Peterson
- RE: Send Userform results to work***
- From: Toppers
- Re: Send Userform results to work***
- Prev by Date: Re: Movve data from rows to columns
- Next by Date: RE: Currency changer
- Previous by thread: Printing in reverse order
- Next by thread: RE: Send Userform results to work***
- Index(es):