use a defined name for the source for the listbox.
Insert = Name = Define
Name: List1
Refersto: =Offset(ClientInfo!A1,0,0,countA(ClientInfo!A:A),1 )
http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data
http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"
http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel
--
Regards,
Tom Ogilvy
"steve_doc" wrote in message
...
Hi all
Hoping someone will be able to point me in the right direction.
Am creating a spreadsheet that a records new client data and enters it on
sheet 1,via a userform.
From sheet 2 onwards are individual client acounts.
Question 1
on userform2 i need to create a list box from the client info on sheet 1,
as this is a dynamic range, i am not sure of the coding for this, is this
possible?
Question 2
On completion of data on form2, all data to be posted out to respective
client accounts,not sure of the coding for this?
Question 3
Is it possible that on entry of a new client, a new client accound sheet
could be created?
Many thanks in advance for any direction with this
Steve