UserForm and combo box to another sheet
Hi,
i need to create 2 things.
1. a userform to add new contact & client details to a hidden data sheet
2. a combo box in an excel sheet to use the information from the hidden sheet.
I have found a combobox and data on the same sheet thanks to Deborah
Dalgleish's site information which states that the data can br created on
another sheet. however, i cannot fint how to link the "listfillrange" to it.
The userform should appear with the press of a button and have the following:
contact name, Company, address, phone number, mobile number.
when appy is pressee, the info goes underneath the last inputted date in the
same range.( i have a code to automatically find the next mpty cell).
Can anyone help me with this?
Regards,
nigel
|